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

On 2013-12-07 15:28:44 +0100, Strahinja Kustudi=C4=87 wrote:
> Could you please tell me do I need to reinitialize the hot standby serv=
er
> after I upgrade to the latest version? In the release logs it says a fr=
esh
> base backup is only needed if the version is 9.1.10, but I had 9.1.9 an=
d
> 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 affe=
cted
> and which was never powered of from first start, so I guess that server
> doesn't need to be reinitialized?

Correct.

Greetings,

Andres Freund

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