Tena Sakai wrote:
> Hi Alvaro,
> I just looked in pg_clog directory and there is
> only one file:
> -rw------- 1 postgres postgres 24576 Aug 25 20:18 0000
> I saw the same file about 10:30 am and I believe
> it was roughly the same size. This is a brand new
> installation of 8.3.3.
Maybe initdb was executed? That would cause the files to disappear.
Of course, so would the data; it would have to be restored from a
Note that these files use only 2 bits per transaction, so in 24756 bytes
you have enough room to cover 99024 transactions. Furthermore, they
always grow in 8192-byte increments.
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
In response to
pgsql-admin by date
|Next:||From: Scott Marlowe||Date: 2008-08-26 14:49:32|
|Subject: Re: Bug introduced in 8.0|
|Previous:||From: Rommel the iCeMAn||Date: 2008-08-26 14:19:51|
|Subject: Re: Problem with reinstall of PostgreSQL 8.3|