Re: Help with data recovery...

Rajesh Kumar Mallah. wrote:
> 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

If your hardware is going bad, there's probably not much Pg can do. 18
hours isn't that long ago...if that's not recent enough, you should look
into doing more frequent backups.

--Jeremy