standby shutdown
От | Ray Stell |
---|---|
Тема | standby shutdown |
Дата | |
Msg-id | 20090501131440.GA30465@cns.vt.edu обсуждение исходный текст |
Ответы |
Re: standby shutdown
|
Список | 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 tochoose 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 suchfile 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 suchfile 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
В списке pgsql-admin по дате отправления: