Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes

Поиск
Список
Период
Сортировка
От Strahinja Kustudić
Тема Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes
Дата
Msg-id CADKbJJUA33gepAnQ-BOSdhATFjwHzu5+6=S1Ay4ukDs4qYXF8A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-bugs
Дерево обсуждения
Thanks for your help and especially for fast responses :)


Strahinja Kustudić | Lead System Engineer | Nordeus


On Sat, Dec 7, 2013 at 3:33 PM, Andres Freund <andres@2ndquadrant.com> wrote:
On 2013-12-07 15:28:44 +0100, Strahinja Kustudić wrote:
> Could you please tell me do I need to reinitialize the hot standby server
> after I upgrade to the latest version? In the release logs it says a fresh
> base backup is only needed if the version is 9.1.10, but I had 9.1.9 and
> still had a related issue. I didn't power off Postgres on the stand by
> after I made a new fresh base backup.

The bug you had should be fixed by simply upgrading and restart, without recloning.

> We also have a hot standby server running 9.2.4 which shouldn't be affected
> and which was never powered of from first start, so I guess that server
> doesn't need to be reinitialized?

Correct.

Greetings,

Andres Freund

--
 Andres Freund                     http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes
Следующее
От: cbfgterfdy@zacglen.net
Дата:
Сообщение: BUG #8662: psql -H and ts_headline