pg_standby question
От | Pavel Stehule |
---|---|
Тема | pg_standby question |
Дата | |
Msg-id | 162867790705130620i13a4b226rcf51de6d8a43f02f@mail.gmail.com обсуждение исходный текст |
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: