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

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: Strahinja Kustudić <strahinjak(at)nordeus(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes
Date: 2013-12-07 14:33:55
Message-ID: 20131207143355.GA21734@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Strahinja Kustudić 2013-12-07 14:55:28 Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes
Previous Message Strahinja Kustudić 2013-12-07 14:28:44 Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes