From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Shane <shane-pgsql(at)cm(dot)nu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Database corruption |
Date: | 2007-05-19 01:11:58 |
Message-ID: | 20070519011158.GA31543@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Shane wrote:
> Hello all,
>
> Whilst running a regular pg_dumpall, I received the
> following error from our spamassassin DB.
>
> pg_dump: ERROR: could not access status of transaction
> 4521992
> DETAIL: could not open file "pg_clog/0004": No such file
> or directory
> pg_dump: SQL command to dump the contents of table
> "bayes_token" failed: PQendcopy() failed.
> pg_dump: Error message from server: ERROR: could not
> access status of transaction 4521992
> DETAIL: could not open file "pg_clog/0004": No such file
> or directory
> pg_dump: The command was: COPY public.bayes_token (id,
> token, spam_count, ham_count, atime) TO stdout;
> pg_dumpall: pg_dump failed on database "spamassassin",
> exiting
>
> It's clear something's amiss with the database but I'm not
> sure where to go from here. Is any data from bayes_token
> recoverable, should I just delete the data in that table or
> does the whole database need to be dropped and recreated?
Hang on. You may still recover the data. What range of files do you
see in the pg_clog directory? Also, what version is this?
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2007-05-19 01:14:27 | Re: Data replication through disk replication |
Previous Message | Ben | 2007-05-19 00:03:30 | Re: Data replication through disk replication |