[EMAIL PROTECTED] writes:
> If in two words - i have file system level backup and i can see manually
> all the data in it, but PostreSQL doesn`t. What can i do?
You messed up the backup/restore somehow: the system is running with a
transaction counter much less than what it was when you took the backup
(in fact, less than what it was when you created the "missing" tables).
So all the catalog rows appear to be "in the future".
You sure you backed up *all* of $PGDATA, including pg_xlog, pg_global,
and so on?
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
