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

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(at)2ndquadrant(dot)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
>