Re: [URGENT] Problems recovering database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [URGENT] Problems recovering database
Дата
Msg-id 3500.1052948416@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [URGENT] Problems recovering database  (Bruno Mattarollo <bruno@web1.greenpeace.org>)
Ответы Re: [URGENT] Problems recovering database
Список pgsql-admin
Bruno Mattarollo <bruno@web1.greenpeace.org> writes:
> Thanks for the tip. It worked to start the DB but when I issue:
> psql -l
> I can't see my databases :(

You need to set the next transaction ID higher (pg_resetxlog -x).
I'd try 2 billion (2000000000) for starters.

You should probably also be setting the WAL start location (-l)
somewhere past the evidently-already-existing segments ("-l 2,0"
should do, I think).

Needless to say, initdb and reload as soon as you have managed to
get a good dump.

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: Bruno Mattarollo
Дата:
Сообщение: Re: [URGENT] Problems recovering database
Следующее
От: Bruno Mattarollo
Дата:
Сообщение: Re: [URGENT] Problems recovering database