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

Re: Missing pg_clog files

From: Carol Walter <walterc(at)indiana(dot)edu>
To: Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Missing pg_clog files
Date: 2008-09-23 22:35:01
Message-ID: 1B5F9FC4-578A-44FA-8264-FC674CF5A0FD@indiana.edu (view raw or flat)
Thread:
Lists: pgsql-admin
Hi, Tena,

Yes, you do recall correctly.  It is Solaris 10 and Postgres 8.2.3.

I'm going to run a pg_dumpall and keep my fingers crossed.  I'm  
getting similar errors when I try to do other things like vacuumdb,  
so maybe pg_dumpall won't run either.

Carol
On Sep 23, 2008, at 6:13 PM, Tena Sakai wrote:

> 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
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>

In response to

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-09-23 23:56:09
Subject: Re: Missing pg_clog files
Previous:From: Tena SakaiDate: 2008-09-23 22:13:11
Subject: Re: Missing pg_clog files

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