Oskars Ozols wrote:
We were successfully running PostgreSQL 8.0 on Win2003 for several
months without downtime.
Then suddenly PostgreSQL crashed and there were following info in log file
[snip]
2005-10-09 03:51:24 PANIC: could not rename file "C:/Program
Files/PostgreSQL/8.0/data/pg_xlog/0000000100000000000000CD" to
"C:/Program Files/PostgreSQL/8.0/data/pg_xlog/0000000100000000000000D2"
(initialization of log file 0, segment 210): No such file or directory
[snip]
2005-10-09 03:51:24 LOG: all server processes terminated; reinitializing
2005-10-09 03:51:24 LOG: database system was interrupted at 2005-10-09
03:51:24 FLE Daylight Time
2005-10-09 03:51:24 LOG: checkpoint record is at 0/CE030078
2005-10-09 03:51:24 LOG: redo record is at 0/CE030078; undo record is
at 0/0; shutdown FALSE
2005-10-09 03:51:24 LOG: next transaction ID: 140670456; next OID: 3537664
2005-10-09 03:51:24 LOG: database system was not properly shut down;
automatic recovery in progress
2005-10-09 03:51:24 LOG: record with zero length at 0/CE0300B8
2005-10-09 03:51:24 LOG: redo is not required
2005-10-09 03:51:24 PANIC: could not rename file "C:/Program
Files/PostgreSQL/8.0/data/pg_xlog/0000000100000000000000CD" to
"C:/Program Files/PostgreSQL/8.0/data/pg_xlog/0000000100000000000000D2"
(initialization of log file 0, segment 210): No such file or directory
What's in your pg_xlog directory?
Oh, and which version of 8.0.x is it exactly?
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
