URGENT! could not access status of transaction

From: "Reimer" <carlosreimer(at)terra(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: URGENT! could not access status of transaction
Date: 2006-03-24 13:41:41
Message-ID: 000f01c64f48$afb2fb60$8b00000a@reimer
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

We had some disk problems here and now pg_dump is complaining with:

pg_dump: ERROR: could not access status of transaction 1768711534
DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0696": Arquivo ou dire
tório não encontrado
pg_dump: SQL command to dump the contents of table "tt_fin" failed: PQendcopy() fa
iled.
pg_dump: Error message from server: ERROR: could not access status of transaction
1768711534
DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0696": Arquivo ou dire
tório não encontrado
pg_dump: The command was: COPY "REIMER".tt_fin (codfil, sequen, tipger, tipnum, co
dusu, filger, filnum, filusu, seqger, seqnum, datope, vlrmov, seqtrn, codctr, codc
us, numdoc, observ, flgfin, chvtrn, atu_em) TO stdout;

I know is something related with the hardware and not with postgresql but I don´t want to restore all the database.

How is the best way to fix? pg_resetxlog?

Thanks in advance!

Reimer

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reimer 2006-03-24 13:51:25 Re: URGENT! could not access status of transaction
Previous Message joseph 2006-03-24 13:27:06 another seemingly simple encoding question