Skip site navigation (1) Skip section navigation (2)

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: 2007-10-31 15:07:16
Message-ID: dcc563d10710310807s1806a617x48472bf10f601dc1@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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.

In response to

pgsql-admin by date

Next:From: Scott MarloweDate: 2007-10-31 16:04:45
Subject: Re: how to check objects dependency??
Previous:From: Jessica RichardDate: 2007-10-31 14:50:51
Subject: how to check objects dependency??

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group