Hi, I have one PostgreSQL 8.3 machine feeding WAL files to another PostgreSQL 8.3 machine that's running in recovery mode. However, fairly often (every few days), the standby machine breaks out of recovery mode with log messages like:
2009-10-23 21:47:40 EDT LOG: incorrect resource manager data checksum in record at 11/4E5AA18C 2009-10-23 21:47:40 EDT LOG: redo done at 11/4E5A9A40 2009-10-23 21:47:40 EDT LOG: last completed transaction was at log time 2009-10-23 21:28:36.531005-04 2009-10-23 21:47:40 EDT LOG: restored log file "00000001000000110000004E" from archive cp: cannot stat `/var/backups/postgres/wal/00000002.history': No such file or directory 2009-10-23 21:47:46 EDT LOG: selected new timeline ID: 2 cp: cannot stat `/var/backups/postgres/wal/00000001.history': No such file or directory 2009-10-23 21:47:52 EDT LOG: archive recovery complete 2009-10-23 21:47:55 EDT LOG: database system is ready to accept connections I'm pretty sure the WAL is shipped correctly (it's shipped via SCP). The only thing I can think of is that the shipping version is 8.3.7 and the consuming version is 8.3.8. Would this be enough to cause the "incorrect checksum" message? Regards, David. -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
