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

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