my postmaster is refusing to startup. and my last backup is 18 hrs old.
restoring data for that backup is the last option i have.
I have already tried pg_resetxlog -f $PGDATA , but that sets the
database to a state that is 2 days old.
will anyone please help me with my best bet in recovering data
i made a copy of it before running pg_resetxlog.
DEBUG: database system was interrupted being in recovery at 2002-05-16 21:34:20 IST
This probably means that some data blocks are corrupted
and you will have to use the last backup for recovery.
DEBUG: checkpoint record is at 3/FACBFA78
DEBUG: redo record is at 3/FACBFA78; undo record is at 0/0; shutdown FALSE
DEBUG: next transaction id: 6174305; next oid: 30144904
DEBUG: database system was not properly shut down; automatic recovery in progress
DEBUG: redo starts at 3/FACBFAB8
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
pgsql-admin by date
|Next:||From: Rajesh Kumar Mallah.||Date: 2002-05-16 16:25:28|
|Subject: Help with data recovery... (pg_controldata output)|
|Previous:||From: Jeremy Buchmann||Date: 2002-05-16 15:54:22|
|Subject: Re: Immortal backend .... (kill -9 ?..)|