Hello,
I am using postgres 8.3.1, and have implemented warm standby very much like the one described in the high availability documentation on this site.
It seems to work well except for this problem: I've had a case where the postgresql server was interrupted while in recovery (I think it was a user interrupt, the log sais:
. LOG: received fast shutdown request
LOG: archive recovery complete
FATAL: terminating connection due to administrator command
LOG: startup process (PID 6033) exited with exit code 1
LOG: aborting startup due to startup process failure
And after that, pg doesn't go through the recovery script provided in recovery.conf, and doesn't manage to come up. The log sais:
LOG: database system was interrupted while in recovery at log time 2010-05-26 02:00:03 IDT
HINT: If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target.
LOG: could not open file "pg_xlog/000000CA0000000A0000006D" (log file 10, segment 109): No such file or directory
LOG: invalid primary checkpoint record
LOG: could not open file "pg_xlog/000000CA0000000A0000006D" (log file 10, segment 109): No such file or directory
LOG: invalid secondary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 8081) was terminated by signal 6: Aborted
LOG: aborting startup due to startup process failure
But usually it just goes into my recovery script and there I provide the WAL archive files and put them in the pg_xlog directory.
Do you know if I have to configure someplace what script to use when PG is recovering from a failed recovery? Or is this a bug?
Thanks!