Re: [GENERAL] URGENT! could not access status of transaction

2006-03-24 Thread Reimer
rch 24, 2006 1:11 PM Subject: Re: [GENERAL] URGENT! could not access status of transaction "Reimer" <[EMAIL PROTECTED]> writes: pg_dump: ERROR: could not access status of transaction 1768711534 DETAIL: could not open file "/usr/local/pgsql/data/pg_clog/0696": = Arquivo

Re: [GENERAL] URGENT! could not access status of transaction

2006-03-24 Thread Tom Lane
"Reimer" <[EMAIL PROTECTED]> writes: > 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=F3rio n=E3o encontrado > How is the best way to fix? pg_resetxlog? resetxlog won't help: you've go

Re: [GENERAL] URGENT! could not access status of transaction

2006-03-24 Thread Jim C. Nasby
-- Original Message - > From: Reimer > To: pgsql-general@postgresql.org > Sent: Friday, March 24, 2006 10:41 AM > Subject: [GENERAL] URGENT! could not access status of transaction > > > Hello, > > We had some disk problems here and now pg_dump is complaining

Re: [GENERAL] URGENT! could not access status of transaction

2006-03-24 Thread Reimer
I forgot to mention postgreSQL version: 7.4.6   Thanks! - Original Message - From: Reimer To: pgsql-general@postgresql.org Sent: Friday, March 24, 2006 10:41 AM Subject: [GENERAL] URGENT! could not access status of transaction Hello,   We had some

[GENERAL] URGENT! could not access status of transaction

2006-03-24 Thread Reimer
Hello,   We had some disk problems here and now pg_dump is complaining with:   pg_dump: ERROR:  could not access status of transaction 1768711534DETAIL:  could not open file "/usr/local/pgsql/data/pg_clog/0696": Arquivo ou diretório não encontradopg_dump: SQL command to dump the contents of