Re: Something wrong after file system level backup - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Something wrong after file system level backup
Date
Msg-id 9526.1129567167@sss.pgh.pa.us
Whole thread Raw
In response to Something wrong after file system level backup  (alex@yauza.ru)
List pgsql-hackers
alex@yauza.ru 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: libpq's pollution of application namespace
Next
From: Tony Caduto
Date:
Subject: Re: More problems with the win32 installer for 8.1 beta3