Re: Something wrong after file system level backup

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: alex(at)yauza(dot)ru
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Something wrong after file system level backup
Date: 2005-10-17 16:39:27
Message-ID: 9526.1129567167@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

alex(at)yauza(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tony Caduto 2005-10-17 16:43:25 Re: More problems with the win32 installer for 8.1 beta3
Previous Message Tom Lane 2005-10-17 16:20:06 Re: libpq's pollution of application namespace