| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | simon(at)2ndquadrant(dot)com |
| Subject: | pg_standby question |
| Date: | 2007-05-13 13:20:40 |
| Message-ID: | 162867790705130620i13a4b226rcf51de6d8a43f02f@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2007-05-13 13:39:45 | Re: Concurrent psql patch |
| Previous Message | Magnus Hagander | 2007-05-13 13:01:55 | Re: What is happening on buildfarm member baiji? |