Skip site navigation (1) Skip section navigation (2)

Re: Removed and then missing pg_clog file

From: Amin Abdulghani <amin(at)quantiva(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Removed and then missing pg_clog file
Date: 2004-09-24 18:41:27
Message-ID: web-1831873@quantiva.com (view raw or flat)
Thread:
Lists: pgsql-general
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


In response to

pgsql-general by date

Next:From: Josué MaldonadoDate: 2004-09-24 19:21:06
Subject: Optmizar query
Previous:From: Tom LaneDate: 2004-09-24 18:40:48
Subject: Re: pg_dump: what is advantage with schema and data dumps?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group