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

Re: Missing pg_clog files

From: Carol Walter <walterc(at)indiana(dot)edu>
To: "Walter, Carol Williams" <walterc(at)indiana(dot)edu>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Missing pg_clog files
Date: 2008-09-24 12:42:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

I tried creating the files 0000 through 002F.  Pg_dump still will not  
run.  The error was as follows:

-bash-3.00$ pg_dump -U postgres ebiz > ebiz_bk.sql
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  could not access status  
of transaction 20080015
DETAIL:  Could not read from file "pg_clog/0013" at offset 32768:  
Error 0.
pg_dump: The command was: COPY ebizd.products_categories  
(category_id, product_id) TO stdout;


On Sep 24, 2008, at 7:13 AM, Walter, Carol Williams wrote:

> Hello,
> I will try this.  Is there a particular size these files need to  
> be?  Then I can try the pg_dumpall.  That's, of course, my main  
> concern.  I need to get the data out.
> By the way, before I went to panic mode, I tried pg_dumpall and  
> reindexing the database.  Everything gets the same error, perhaps  
> with a different file name.
> Carol
> Quoting Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>:
>> On Tue, Sep 23, 2008 at 10:16 PM, Tena Sakai  
>> <tsakai(at)gallo(dot)ucsf(dot)edu> wrote:
>>> Hi Carol,
>>> I detect in you some apprehension as to pg_dumpall
>>> won't run or complete.  Why is that?  Have you already
>>> done it and it didn't work?  If that's not the case,
>>> why not run pg_dumpall at a quiet hour and see?
>>> I think Scott is right as to install the latest
>>> 8.2 on top.  It won't be time consuming task.
>>> Why not give it a wheel?  It would be good to
>>> find out one way or the other.
>>> Scott: Are files 0000 through 002F (which are
>>> not there) absolutely necessary for recovering data?
>> Most likely not.  If the db won't start up without them, it might be
>> possible to create new clog files that are nothing but zeroes.  Never
>> been in this position though...
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
>> To make changes to your subscription:
> -- 
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:

In response to


pgsql-admin by date

Next:From: Tom LaneDate: 2008-09-24 13:10:21
Subject: Re: Missing pg_clog files
Previous:From: Walter, Carol WilliamsDate: 2008-09-24 11:13:08
Subject: Re: Missing pg_clog files

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