Re: Cannot rename file pg_xlog\0000.....

On 11/3/06, Shane Ambler <pgsql(at)007marketing(dot)com> wrote:
>
> 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[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | yahoo }.com