Thread: Postgresql Database Corrupted

Postgresql Database Corrupted

From
karthik keyan
Date:
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
 
 

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Re: Postgresql Database Corrupted

From
"Scott Marlowe"
Date:
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.