Peter Eisentraut <peter_e@xxxxxxx> 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
