Re: Something wrong after file system level backup

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Something wrong after file system level backup
Дата
Msg-id 9526.1129567167@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Something wrong after file system level backup  (alex@yauza.ru)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: libpq's pollution of application namespace
Следующее
От: Tony Caduto
Дата:
Сообщение: Re: More problems with the win32 installer for 8.1 beta3