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
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com
