Thanks, all of you, for all good advice and suggestions.
Andres Freund wrote:
>Afaik debian has never shipped 9.0 in any stable release at all. You can
>use the packages provided by the postgres community though, they are
>compatible:
>http://wiki.postgresql.org/wiki/Apt
I used this to upgrade to 9.0.13, which indeed is fully compatible with
Debian. It started up like a charm. I can upgrade it to 9.1.9 now
(while I'm at it).
For reference, the startup log now looked like this:
LOG: database system was interrupted while in recovery at 2013-04-09 19:45:49 CESTFATAL: the database system is
startingupHINT: This probably means that some data is corrupted and you will have to use the last backup for
recovery.LOG: incomplete startup packetLOG: database system was not properly shut down; automatic recovery in
progressLOG: redo starts at D/B0BAB734LOG: record with zero length at D/B0D3D71CLOG: redo done at D/B0D3D6E0LOG:
lastcompleted transaction was at log time 2013-04-09 15:02:24.848947+02LOG: checkpoint starting: end-of-recovery
immediateLOG: checkpoint complete: wrote 423 buffers (11.8%); 0 transaction log file(s) added, 0 removed, 0 recycled;
write=0.003s, sync=11.419 s, total=11.601 s
So, Tom, thanks for fixing that WAL recovery code :-).
--
Stephen.