Help with data recovery...

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.