Re: PostgreSQL terminated abnormally

Oskars Ozols <oskars(dot)ozols(at)di(dot)lv> writes:
> 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

> 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

This is a logically impossible failure: the only way to reach the point
at which this message is emitted (InstallXLogFileSegment) is if the
program just saw file 0000000100000000000000CD in that directory. But
rename() failing with "No such file or directory" means the file *isn't*
there. And it's not a case of someone else having deleted it in the
intervening microseconds, because the error is reproducible.

The only idea that comes to mind is that you've got an antivirus product
interfering with disk accesses. We've seen reports recently of equally
bizarre failures that went away after disabling some antivirus program.

My own advice: get a real operating system ;-)

regards, tom lane