Mike G wrote: > I have noticed that in the event logs that I am again seeing errors about the renaming: > LOG: could not rename file > "pg_xlog/000000010000006900000021" to "pg_xlog/000000010000006900000030" continuing to try
Sounds to me like it might be a Windows issue with the file - probably damaged when the plug was pulled.
First I would try and manually do the rename postgres attempted then try and delete pg_xlog/000000010000006900000021 or at least move it out of the xlog dir.
If you can't delete or rename the file one possibility is permissions on the file.
If you can move it but not delete it then move it somewhere and forget about it.
I have seen a few examples of bad files that windows (2000 server) can't delete and have had to sit there and be ignored.
Try to find the application that is probably holding a handle on this file. For this you can use ProcessExplorer from sysinternals.com
