Peter Eisentraut <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
