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. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(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
