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