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