[HACKERS] Can't Restart ver 8.0b3

2004-12-22 Thread Dave Hartwig
Anyone, I would not describe my situation as desprate (yet), but it is painful, and I am looking for some information and a degree of confidence. I have yet to communicate w/ our sysadmin about backup/restore. We are using version 8.0 beta 3, on Red Hat Linux, to develop a product that we plan

Re: [HACKERS] Can't Restart ver 8.0b3

2004-12-22 Thread Tom Lane
Dave Hartwig [EMAIL PROTECTED] writes: LOG: next transaction ID: 884736; next OID: 306834 PANIC: could not access status of transaction 884736 DETAIL: could not read from file /usr/local/pgsql8b3/data/pg_clog/ at offset 221184: Success LOG: startup process (PID 17774) was terminated

Re: [HACKERS] Can't Restart ver 8.0b3

2004-12-22 Thread Dave Hartwig
Bingo! Thanks Tom. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 11:33 AM To: Dave Hartwig Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Can't Restart ver 8.0b3 Dave Hartwig [EMAIL PROTECTED] writes: LOG: next transaction ID

Re: [HACKERS] Can't Restart ver 8.0b3

2004-12-22 Thread Tom Lane
I wrote: Dave Hartwig [EMAIL PROTECTED] writes: LOG: next transaction ID: 884736; next OID: 306834 PANIC: could not access status of transaction 884736 DETAIL: could not read from file /usr/local/pgsql8b3/data/pg_clog/ at offset 221184: Success LOG: startup process (PID 17774) was