Re: 7.4 - data recovery

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Bartosz Belter wrote:
>> 3. I've recovered some files and it looks to me they're from
>> $PGDATA/base/data/xxx (it looks this is the complete folder)
>> 4. No other files! (no pg_clog, pg_xlog etc)

> If you don't have a clog, then all your transactions will appear
> as "didn't happen yet", so your table data appears to be in the future.
> You can just commit dummy transactions until it appears again. This is
> obvious not an official and approved way, but it's at least a shot
> before you're forced to get out your hex editor.

Less painfully, use pg_resetxlog to push the XID and WAL counters up
past what's in the database. The problem is to know where to set them
:-(

regards, tom lane