Re: Removed and then missing pg_clog file

Note

1) the clog file was automatically removed.
2) There are multiple databases with only one database
specific vacuums
3) The other database does table specific vacuums.

Amin

On Fri, 24 Sep 2004 11:20:49 -0400
Amin Abdulghani <amin(at)quantiva(dot)com> wrote:
>Hi,
>
>
>We about a week ago installed a clean version of postgres
>7.4.5 for testing purposes. For the last couple of days
>for any transaction it has been complaining about: Thu
>Sep 23 09:36:24 2004: ERROR: could not access status of
>transaction 941262
>Thu Sep 23 10:10:01 2004: DETAIL: could not open file
>"/nw/data/pgdata/pg_clog/0000": No such file or directory
>Thu Sep 23 10:10:01 2004: ERROR: could not access status
>of transaction 941355
>Thu Sep 23 10:10:06 2004: DETAIL: could not open file
>"/nw/data/pgdata/pg_clog/0000": No such file or directory
>
>Now looking at the postgres logfile it also says (meaning
>that it removed the log file thinking it was safe to
>remove it):
>
>Thu Sep 23 07:40:02 2004: LOG: removing file
>"/nw/data/pgdata/pg_clog/0000"
>
>
>What might be causing this error to occur?
>
>Thanks..
>Amin
>
>---------------------------(end of
>broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html