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 CADKbJJVcstVdrhQMGZJTsF6oMEwY7De2S5FV=3tUOf4JzbDaww@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-bugs
Дерево обсуждения
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.

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?


Strahinja Kustudić | Lead System Engineer | Nordeus


On Thu, Nov 28, 2013 at 5:17 PM, Andres Freund <andres@2ndquadrant.com> wrote:
On 2013-11-28 11:13:22 -0500, Bruce Momjian wrote:
> > > > No, it's actually not - the (buggy) bug fix for the issue you're having
> > > > caused the problem in 9.1.10. So 9.1.11 will contain the corrected
> > > > version...
> > >
> > > I believe all the issues are summarized here:
> > >
> > >   https://wiki.postgresql.org/wiki/Nov2013ReplicationIssue
> >
> > Note that the OP is not hitting the bug that can cause actual corruption
> > in the standby that's discussed on that page.
>
> Oh, that's interesting.

He's hitting the issue that was the raison d'etre for the buggy fix that
caused the issue discussed on that page... As explained in the message
you replied to ;)

Greetings,

Andres Freund

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

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

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: BUG #8659: Broken dependencies on RHEL6 for 9.2.6 RPMs
Следующее
От: Andres Freund
Дата:
Сообщение: Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes