[Pgpool-general] Checking postgreSQL log entries after online-recovery

[Mark White]

> You did not set recovery.conf properly?

I'm flying by the seat of my pants here, so it's quite possible...

My scripts are copied from Marcelo's:
(http://pgfoundry.org/pipermail/pgpool-general/2008-December/001407.html)

The relevant lines in copy_base_script are:

(activate WAL archiving, pg_start_backup, rsync, pg_stop_backup)

echo "restore_command = 'rsync -pog -e \"ssh -o StrictHostKeyChecking=no 
-i /var/lib/postgresql/.ssh/XXX.pem\" 
$HOSTNAME:/data/main/wal_archive/%f %p'" > /tmp/recovery.conf

scp -o StrictHostKeyChecking=no -i /var/lib/postgres/.ssh/XXX.pem 
/tmp/recovery.conf $RECV_NODE:/data/main/recovery.conf 2>/dev/null 
1>/dev/null

> during archiving, during base backup or after it (stop_backup()
> generates one last file at least)?

I am getting files transferred, but it doesn't look like a complete set.

Source instance:
root at XXX:/data/main# ls -la wal_archive/
drwxr-xr-x  2 postgres postgres     4096 2010-06-15 07:19 .
drwx------ 12 postgres postgres     4096 2010-06-15 07:19 ..
-rw-------  1 postgres postgres 16777216 2010-06-15 07:19 
0000000200000000000000A0
-rw-------  1 postgres postgres 16777216 2010-06-15 07:19 
0000000200000000000000A1
-rw-------  1 postgres postgres      256 2010-06-15 07:19 
0000000200000000000000A1.00000020.backup
-rw-------  1 postgres postgres 16777216 2010-06-15 07:19 
0000000200000000000000A2

Target instance:
root at XXX:/data/main# ls -la pg_xlog/
drwx------  3 postgres postgres     4096 2010-06-15 07:19 .
drwx------ 12 postgres postgres     4096 2010-06-15 07:19 ..
-rw-------  1 postgres postgres 16777216 2010-06-15 07:19 
0000000300000000000000A2
-rw-------  1 postgres postgres 16777216 2010-06-15 07:29 
0000000300000000000000A3
-rw-------  1 postgres postgres       74 2010-06-15 07:19 00000003.history
drwx------  2 postgres postgres     4096 2010-06-15 07:29 archive_status

I can post full scripts, but don't want to swamp the mailing list if 
there's no need.

Thanks for any advice.


Mark...