Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes
Date
Msg-id 20131207143355.GA21734@awork2.anarazel.de
Whole thread Raw
In response to Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes  (Strahinja Kustudić <strahinjak@nordeus.com>)
Responses Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes  (Strahinja Kustudić <strahinjak@nordeus.com>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Strahinja Kustudić
Date:
Subject: Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes
Next
From: Strahinja Kustudić
Date:
Subject: Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes