From: | "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu> |
---|---|
To: | "Carol Walter" <walterc(at)indiana(dot)edu>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Missing pg_clog files |
Date: | 2008-09-23 22:13:11 |
Message-ID: | FE44E0D7EAD2ED4BB2165071DB8E328C0378F509@egcrc-ex01.egcrc.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Carol,
I don't have answer...
I have had a similar problem and whatever I
did didn't work. As I recall, the files in
pg_clog directory started from 0000 and the
number got bigger by 1 (hex) and there was
a gap between the most recent one and the
second recent one. (Is that how you know
that you are missing about 30 files?) I
suspect the reason why it didn't work for me
was because the last file was incomplete. I
wound up upgrading to the latest postgres and
restored from a backup file I made by pg_dumpall.
My platform is linux (do I recall yours is solaris?)
and the postgres version I was running was 8.3.0.
The lesson I learned was to keep an eye on the
pg_clog directory. Since the installation of
8.3.3 there has been only one file (0000), though
the size keeps growing (I think by 8k bytes).
My two bits.
Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu
-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org on behalf of Carol Walter
Sent: Tue 9/23/2008 2:31 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Missing pg_clog files
I'm missing about 30 pg_clog files. How do I recover from this?
Carol
From | Date | Subject | |
---|---|---|---|
Next Message | Carol Walter | 2008-09-23 22:35:01 | Re: Missing pg_clog files |
Previous Message | Carol Walter | 2008-09-23 21:31:18 | Missing pg_clog files |