standby shutdown

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: standby shutdown
Date: 2009-05-01 13:14:40
Message-ID: 20090501131440.GA30465@cns.vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I need to do OS maintenance on a system running a standby in recovery
using pg_standby. I've gotten mixed results with doing the stop/start
with pg_ctl. Sometimes the standby is not recoverable. What should
the shutdown script look like if the standby is to be usable on the
other side? The log seems to indicate that interuption of recovery
is bad. What should the script look for to avoid that?

"-m i" left it in this state:

2009-05-01 00:42:15 EDT,0, LOG: database system was interrupted while in recovery at log time 2009-05-01 00:34:06 EDT
2009-05-01 00:42:15 EDT,0, HINT: If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target.
2009-05-01 00:42:15 EDT,0, LOG: could not open file "pg_xlog/00000001000000000000000A" (log file 0, segment 10): No such file or directory
2009-05-01 00:42:15 EDT,0, LOG: invalid primary checkpoint record
2009-05-01 00:42:15 EDT,0, LOG: could not open file "pg_xlog/000000010000000000000009" (log file 0, segment 9): No such file or directory
2009-05-01 00:42:15 EDT,0, LOG: invalid secondary checkpoint record
2009-05-01 00:42:15 EDT,0, PANIC: could not locate a valid checkpoint record
2009-05-01 00:42:14 EDT,0, LOG: startup process (PID 25121) was terminated by signal 6: Aborted
2009-05-01 00:42:14 EDT,0, LOG: aborting startup due to startup process failure

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Treat 2009-05-02 04:13:42 Re: standby shutdown
Previous Message Robert Ladyman 2009-04-30 08:48:40 Re: Anyone tried storing software users as database users?