Re: Postgresql Database Corrupted

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.