Hello, we currently setup a standby database with archive_command sending the WALs from master to standby. This works as expected, but the standby database doesn't restore the WALs from the given directory in recovery.conf and I have no idea why... recovery.conf: ---------------- restore_command = '/usr/bin/pg_standby -d -s 20 -t /tmp/pgsql.trigger.5432 /var/lib/pgsql/wal_exchange %f %p %r 2>> /var/lib/pgsql/data/pg_log/standby.log' The file standby.log contains: -------------------------------- Trigger file : /tmp/pgsql.trigger.5432 Waiting for WAL file : 00000001.history WAL file path : /var/lib/pgsql/wal_exchange/00000001.history Restoring to... : pg_xlog/RECOVERYHISTORY Sleep interval : 20 seconds Max wait interval : 0 forever Command for restore : cp "/var/lib/pgsql/wal_exchange/00000001.history" "pg_xlog/RECOVERYHISTORY" Keep archive history : 000000000000000000000000 and later running restore :cp: cannot stat `/var/lib/pgsql/wal_exchange/00000001.history': No such file or directory cp: cannot stat `/var/lib/pgsql/wal_exchange/00000001.history': No such file or directory cp: cannot stat `/var/lib/pgsql/wal_exchange/00000001.history': No such file or directory cp: cannot stat `/var/lib/pgsql/wal_exchange/00000001.history': No such file or directory not restored : history file not found Trigger file : /tmp/pgsql.trigger.5432 Waiting for WAL file : 000000010000001E0000001D.00000020.backup WAL file path : /var/lib/pgsql/wal_exchange/000000010000001E0000001D.00000020.backup Restoring to... : pg_xlog/RECOVERYHISTORY Sleep interval : 20 seconds Max wait interval : 0 forever Command for restore : cp "/var/lib/pgsql/wal_exchange/000000010000001E0000001D.00000020.backup" "pg_xlog/RECOVERYHISTORY" Keep archive history : 000000000000000000000000 and later WAL file not present yet. Checking for trigger file... WAL file not present yet. Checking for trigger file... WAL file not present yet. Checking for trigger file... WAL file not present yet. Checking for trigger file... WAL file not present yet. Checking for trigger file... ------------------------------- And in the directory "/var/lib/pgsql/wal_exchange" I have dozens of WALs in the meantime, but they didn't get restored, and in the logs I receive "WAL file not present...." The file "pg_xlog/RECOVERYHISTORY" doesn't exist, btw..., and the file xx00000020.backup contains: "" START WAL LOCATION: 1E/1D000020 (file 000000010000001E0000001D) STOP WAL LOCATION: 1E/1F000000 (file 000000010000001E0000001E) CHECKPOINT LOCATION: 1E/1D000020 START TIME: 2010-08-03 21:11:23 CEST LABEL: initial_backup STOP TIME: 2010-08-03 21:44:06 CEST "" I can stop and restart the standby db as often as I want ending up in a working sync-mechanism, as long as the WALs being copied from master to standby, right ? Any help appreciated, many thanks .....GERD..... -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
