Fellows, Im installing a system with High Availability using Postgres and making some tests.
I have one machine running 2 postgres one in 5432 and other in 6543 with everything apart. The test I made and got this message (PANIC: could not locate a valid checkpoint record) is 1) everything is stoped 2) start pg1 3) restore dump on pg1 4) stop pg1 5) configure pg1 for archiving on /home/postgres/archives 4) copy data dir to pg2 5) start pg1 and create some tables to generate data volume 6) configure pg2 for recovery mode coping from /home/postgres/archives 7) start pg2 (this start is fine, everything was recovered) 8) stop pg2 9) generate more data on pg1 (there are more 2 or 3 archives file) 10) start pg2 on recovery mode again and got this message PANIC: could not locate a valid checkpoint record I try many config combinations and always got this error. Is there anyone who could help-me??? some logs to help FIRST RESTORE [EMAIL PROTECTED] ~]$ /usr/local/recovery_pgsql/bin/postgres -D /usr/local/recovery_pgsql/data LOG: database system was shut down at 2007-06-04 16:50:59 EDT LOG: starting archive recovery LOG: restore_command = "cp /home/postgres/archives/%f %p" cp: cannot stat `/home/postgres/archives/00000001.history': No such file or directory LOG: restored log file "000000010000000000000005" from archive LOG: checkpoint record is at 0/59D38E0 LOG: redo record is at 0/59D38E0; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 0/1341; next OID: 17045 LOG: next MultiXactId: 1; next MultiXactOffset: 0 LOG: automatic recovery in progress LOG: redo starts at 0/59D3928 LOG: restored log file "000000010000000000000006" from archive LOG: restored log file "000000010000000000000007" from archive cp: cannot stat `/home/postgres/archives/000000010000000000000008': No such file or directory LOG: unexpected pageaddr 0/1000000 in log file 0, segment 8, offset 0 LOG: redo done at 0/7FFFE50 LOG: restored log file "000000010000000000000007" from archive LOG: archive recovery complete LOG: database system is ready LOG: received smart shutdown request LOG: shutting down LOG: database system is shut down SECOND RESTORE [EMAIL PROTECTED] ~]$ /usr/local/recovery_pgsql/bin/postgres -D /usr/local/recovery_pgsql/data LOG: database system was shut down at 2007-06-04 17:07:45 EDT LOG: starting archive recovery LOG: restore_command = "cp /home/postgres/archives/%f %p" cp: cannot stat `/home/postgres/archives/00000001.history': No such file or directory LOG: restored log file "000000010000000000000008" from archive LOG: contrecord is requested by 0/8000020 LOG: invalid primary checkpoint record LOG: restored log file "000000010000000000000007" from archive LOG: invalid record length at 0/7FFFFB4 LOG: invalid secondary checkpoint record PANIC: could not locate a valid checkpoint record LOG: startup process (PID 30004) was terminated by signal 6 LOG: aborting startup due to startup process failure
