Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Postgresql Database Corrupted
- From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
- To: "karthik keyan" <karthik_arnold1(at)yahoo(dot)com>
- Cc: pgsql-admin(at)postgresql(dot)org
- Subject: Re: Postgresql Database Corrupted
- Date: Wed, 31 Oct 2007 10:07:16 -0500
On 10/30/07, karthik keyan <karthik_arnold1(at)yahoo(dot)com> wrote: > Hi admins > > I have a issue with my database . > > Its not starting up after /var got filled up > > After clearing some space still the database doesnt start up .. > > Pls find the log vacuumdb: vacuuming of database "insight_v1_0" failed: > ERROR: could not access status of transaction 124321809 > DETAIL: could not read from file > "/var/lib/pgsql/data/pg_clog/0076" at offset 147456: > Success So, how did you clear some space? Did that involve deleting the file listed above? If not, you might be able to recreate the pg_clog/0076 file as a file filled with zeroes to get it back up, but who knows what data you might be missing.
- References:
- Postgresql Database Corrupted
- From: karthik keyan
- Postgresql Database Corrupted
- Prev by Date: how to check objects dependency??
- Next by Date: Re: how to check objects dependency??
- Previous by thread: Postgresql Database Corrupted
- Next by thread: another transaction ID question:
- Indexes: