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

From Strahinja Kustudić
Subject Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes
Date
Msg-id CADKbJJUA33gepAnQ-BOSdhATFjwHzu5+6=S1Ay4ukDs4qYXF8A@mail.gmail.com
Whole thread Raw
In response to Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-bugs
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@2ndquadrant.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

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes
Next
From: cbfgterfdy@zacglen.net
Date:
Subject: BUG #8662: psql -H and ts_headline