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

Re: Missing pg_clog files

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Carol Walter <walterc(at)indiana(dot)edu>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Missing pg_clog files
Date: 2008-09-24 15:53:37
Message-ID: 5071.1222271617@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Carol Walter <walterc(at)indiana(dot)edu> writes:
> Here is the results of the query you asked for.

>       datname      | datfrozenxid
> ------------------+--------------
>   postgres         |          524
>   ...

Huh.  Postgres should never have removed any of those files with
datfrozenxid this low.  So it seems we have two possible explanations:
* there's something subtly wrong with the TruncateCLOG logic
* the files were removed by something else, ie, human error or
  operating-system failure

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Carol WalterDate: 2008-09-24 18:09:42
Subject: Re: Missing pg_clog files
Previous:From: Tom LaneDate: 2008-09-24 15:44:22
Subject: Re: Missing pg_clog files

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