Hello

I am trying test pg_stand by. I used archive and restore commands via
README.pg_standby.

recovery finish with notice in log:

Trigger file            : <not set>
Waiting for WAL file    : /usr/local/pgsql/archive/000000010000000000000000
WAL file path           : 000000010000000000000000
Restoring to...         : pg_xlog/RECOVERYXLOG
Sleep interval          : 5 seconds
Max wait interval       : 0 forever
Command for restore     : ln -s -f
/usr/local/pgsql/archive/000000010000000000000000 pg_xlog/RECOVERYXLOG
Num archived files kept : all files
running restore         : success
LOG:  restored log file "000000010000000000000000" from archive
LOG:  WAL file is from different system
DETAIL:  WAL file SYSID is 5064031356745932730, pg_control SYSID is
5064031846372728574
LOG:  invalid primary checkpoint record

Trigger file            : <not set>
Waiting for WAL file    : /usr/local/pgsql/archive/000000010000000000000000
WAL file path           : 000000010000000000000000
Restoring to...         : pg_xlog/RECOVERYXLOG
Sleep interval          : 5 seconds
Max wait interval       : 0 forever
Command for restore     : ln -s -f
/usr/local/pgsql/archive/000000010000000000000000 pg_xlog/RECOVERYXLOG
Num archived files kept : all files
running restore         : success
LOG:  restored log file "000000010000000000000000" from archive
LOG:  WAL file is from different system
DETAIL:  WAL file SYSID is 5064031356745932730, pg_control SYSID is
5064031846372728574
LOG:  invalid secondary checkpoint record
PANIC:  could not locate a valid checkpoint record
LOG:  startup process (PID 23521) was terminated by signal 6: Aborted
LOG:  aborting startup due to startup process failure

but all datase clusters was reinicialised before I starting. What is
correct sequence for building replication system?

Regards
Pavel Stehule

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to