Hi ,
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
for $PGDATA
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.