| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2008-08-26 14:49:32 | Re: Bug introduced in 8.0 |
| Previous Message | Rommel the iCeMAn | 2008-08-26 14:19:51 | Re: Problem with reinstall of PostgreSQL 8.3 |