Re: Postgresql Database Corrupted - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Postgresql Database Corrupted
Date
Msg-id dcc563d10710310807s1806a617x48472bf10f601dc1@mail.gmail.com
Whole thread Raw
In response to Postgresql Database Corrupted  (karthik keyan <karthik_arnold1@yahoo.com>)
List pgsql-admin
On 10/30/07, karthik keyan <karthik_arnold1@yahoo.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.

pgsql-admin by date:

Previous
From: yogesh
Date:
Subject: PL/JAVA issues
Next
From: "Scott Marlowe"
Date:
Subject: Re: how to check objects dependency??