Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 11/3/06, Shane Ambler <pgsql@xxxxxxxxxxxxxxxx> 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[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux