<div dir="ltr">This one worked thanks.</div><div class="gmail_extra"><br clear="all"><div><div style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Nathan Brennan | Senior Software Engineer</div>
<div style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><img src="http://healthengine.com.au/images/he_sig.jpg"><br></div><div style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
This message and any attachments contain confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail or attachments (if any). Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail and attachments (if any) from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents or attachments (if any) of this message, which arise as a result of e-mail transmission.</div>
</div>
<br><br><div class="gmail_quote">On Tue, Jul 23, 2013 at 9:52 PM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Looks baseback.sh coming with the doc is broken.<br>
<br>
Can you please try another one which comes with the tutorial on the<br>
pgpool wiki? (<a href="http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2/index.html" target="_blank">http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2/index.html</a>)<br>
<br>
<a href="http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2/basebackup.sh" target="_blank">http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2/basebackup.sh</a><br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
<div class="HOEnZb"><div class="h5"><br>
> Hi,<br>
><br>
> I'm trying to do online recovery with master/slave replication and I'm<br>
> basically copying<br>
> <a href="http://www.pgpool.net/docs/latest/pgpool-en.html#master_slave_mode" target="_blank">http://www.pgpool.net/docs/latest/pgpool-en.html#master_slave_mode</a> but I<br>
> can't figure out how the users work and seem to be getting a "host key<br>
> verification failed" issue.<br>
><br>
> Following the steps I setup the recovery_user and recovery_password for<br>
> this I used the postgresql user "postgres" which I set a password for in<br>
> the database and not the ubuntu user which seems to work, is this correct ?<br>
><br>
> It then says you need to be able to ssh from the primary to the standby<br>
> which I assume uses the user postgres. I have ssh keys setup so I can<br>
> connect from the primary to the standby like so:<br>
> ssh standby as user postres works fine.<br>
><br>
> I have created the basebackup.sh file however I'm not sure why this line<br>
> uses localhost shouldn't it be $desthost ?<br>
> ssh -T localhost mv $destdir/recovery.done $destdir/recovery.conf<br>
><br>
> I have installed pgpool-recovery and updated pgpool_remote_start to use<br>
> /usr/lib/postgresql/9.1/bin/ instead of /usr/local/pgsql/bin/pg_ctl<br>
><br>
><br>
> now when I run pcp_recovery_node like so this is my pgpool console debug<br>
> output<br>
><br>
> pcp_recovery_node -d 10 localhost 9898 postgres postgres 1<br>
> DEBUG: send: tos="R", len=46<br>
> DEBUG: recv: tos="r", len=21, data=AuthenticationOK<br>
> DEBUG: send: tos="D", len=6<br>
> DEBUG: recv: tos="e", len=20, data=recovery failed<br>
> DEBUG: command failed. reason=recovery failed<br>
> BackendError<br>
> DEBUG: send: tos="X", len=4<br>
><br>
><br>
> postgresql primary log<br>
><br>
> pg_start_backup<br>
> -----------------<br>
> 0/12000020<br>
> (1 row)<br>
><br>
> Host key verification failed.<br>
> NOTICE: WAL archiving is not enabled; you must ensure that all required<br>
> WAL segments are copied through other means to complete the backup<br>
> pg_stop_backup<br>
> ----------------<br>
> 0/120000D8<br>
><br>
><br>
> pgpool log<br>
><br>
> 2013-07-23 10:09:36 LOG: pid 7547: starting recovering node 1<br>
> 2013-07-23 10:09:36 LOG: pid 7547: starting recovery command: "SELECT<br>
> pgpool_recovery('basebackup.sh', '10.0.11.150',<br>
> '/var/lib/postgresql/9.1/main/')"<br>
> 2013-07-23 10:09:37 LOG: pid 7547: 1st stage is done<br>
> 2013-07-23 10:09:37 LOG: pid 7547: check_postmaster_started: try to<br>
> connect to postmaster on hostname:10.0.11.150 database:postgres<br>
> user:postgres (retry 0 times)<br>
> 2013-07-23 10:09:37 LOG: pid 7547: check_postmaster_started: failed to<br>
> connect to postmaster on hostname:10.0.11.150 database:postgres<br>
> user:postgres<br>
><br>
><br>
> the check_postmaster_started just keeps repeating for 90seconds which is<br>
> the timeout.<br>
><br>
> postgres standby startup log<br>
><br>
> 2013-07-23 10:18:17 UTC LOG: database system was interrupted; last known<br>
> up at 2013-07-23 10:13:35 UTC<br>
> 2013-07-23 10:18:17 UTC LOG: could not open file<br>
> "pg_xlog/000000010000000000000015" (log file 0, segment 21): No s<br>
> uch file or directory<br>
> 2013-07-23 10:18:17 UTC LOG: invalid checkpoint record<br>
> 2013-07-23 10:18:17 UTC FATAL: could not locate required checkpoint record<br>
> 2013-07-23 10:18:17 UTC HINT: If you are not restoring from a backup, try<br>
> removing the file "/var/lib/postgresql/9 .1/main/backup_label".<br>
> 2013-07-23 10:18:17 UTC LOG: startup process (PID 7020) exited with exit<br>
> code 1<br>
> 2013-07-23 10:18:17 UTC LOG: aborting startup due to startup process<br>
> failure<br>
><br>
><br>
> basically it looks like it started to copy the files then fails ?<br>
</div></div></blockquote></div><br></div>