Re: error

From: Carol Walter <walterc(at)indiana(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: error
Date: 2008-09-24 03:39:11
Message-ID: 54E013EF-787E-4FE0-941C-80A410AA7878@indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I've had no system crashes. I'm embarrassed to say that I may have
inadvertently caused this problem when I was do "house cleaning" a
couple of weeks ago.

When I upgrade, how to I get my data when pg_dumpall won't run?

Carol

On Sep 23, 2008, at 10:42 PM, Tom Lane wrote:

> Carol Walter <walterc(at)indiana(dot)edu> writes:
>> What would cause this error?
>
>> ERROR: could not access status of transaction 10274530
>> DETAIL: Could not open file "pg_clog/0009": No such file or
>> directory.
>
> We've seen that caused by bugs that made Postgres throw away clog
> files
> too soon; but as far as I know those bugs were all squashed in recent
> releases. What PG version is this? What files *are* present in
> pg_clog, and what are their mod times? Have you had any system
> crashes
> recently?
>
> regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tena Sakai 2008-09-24 04:16:27 Re: Missing pg_clog files
Previous Message Carol Walter 2008-09-24 03:35:42 Re: Missing pg_clog files