Unix Technical Forum

pg_standby question

This is a discussion on pg_standby question within the pgsql Hackers forums, part of the PostgreSQL category; --> Hello I am trying test pg_stand by. I used archive and restore commands via README.pg_standby. recovery finish with notice ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-12-2008, 08:40 AM
Pavel Stehule
 
Posts: n/a
Default pg_standby question

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 majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 11:00 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com