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

Re: restoring from dump

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu>
Cc: Marcelo Martins <pglists(at)zeroaccess(dot)org>, jeff(at)frostconsultingllc(dot)com, pgsql-admin(at)postgresql(dot)org
Subject: Re: restoring from dump
Date: 2008-08-26 14:29:59
Message-ID: 20080826142959.GC4920@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-admin
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
backup.

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

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-08-26 14:49:32
Subject: Re: Bug introduced in 8.0
Previous:From: Rommel the iCeMAnDate: 2008-08-26 14:19:51
Subject: Re: Problem with reinstall of PostgreSQL 8.3

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