From: Suhonen Reijo (Valtori) <reijo.suhonen@valtori.fi>
To: Magnus Hagander <magnus@hagander.net>
To: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: VS: BUG #17218: Cluster recovery is not working properly.
Date: Tue, 12 Oct 2021 07:47:12 +0000
Message-ID: <cd85e0d6cdcc4b4a9457172652a17df0@valtori.fi> (raw)
In-Reply-To: <CABUevEy3Y5+Cmc5yPJiouDXb4k3yhumgRFyXntFi3__J1zJm3w@mail.gmail.com>
References: <17218-8883ab20d0a9d915@postgresql.org>
<CABUevEy3Y5+Cmc5yPJiouDXb4k3yhumgRFyXntFi3__J1zJm3w@mail.gmail.com>
Hi,
Thanks for the information.
Regards,
Reijo Suhonen
Lähettäjä: Magnus Hagander <magnus@hagander.net>
Lähetetty: maanantai 11. lokakuuta 2021 13.12
Vastaanottaja: Suhonen Reijo (Valtori) <reijo.suhonen@valtori.fi>; PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Aihe: Re: BUG #17218: Cluster recovery is not working properly.
On Mon, Oct 11, 2021 at 12:09 PM PG Bug reporting form <noreply@postgresql.org<mailto:noreply@postgresql.org>> wrote:
The following bug has been logged on the website:
Bug reference: 17218
Logged by: Reijo Suhonen
Email address: reijo.suhonen@valtori.fi<mailto:reijo.suhonen@valtori.fi>
PostgreSQL version: 14.0
Operating system: Red Hat Enterprise Linux Server 7.9 (Maipo)
Description:
Restoring a cluster to a specific point in time does not work. The restore
ends with the error message "FATAL, XX000," recovery ended before configured
recovery target was reached " and the cluster goes down.
The same test with version 12 works normally.
This doesn't look like a bug. You have specified a recovery target (09:28) that's beyond the end of what's in WAL (09:27:20). You shouldn't do that -- if you want to recover until the end of WAL, you shouldn't specify a target at all.
The behaviour of this case changed in PostgreSQL 13 which is probably why you didn't see it before. https://www.postgresql.org/docs/release/13.0/ has the entry "Generate an error if recovery does not reach the specified recovery target (Leif Gunnar Erlandsen, Peter Eisentraut) Previously, a standby would promote itself upon reaching the end of WAL, even if the target was not reached.".
--
Magnus Hagander
Me: https://www.hagander.net/<http://www.hagander.net/;
Work: https://www.redpill-linpro.com/<http://www.redpill-linpro.com/;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: reijo.suhonen@valtori.fi, magnus@hagander.net, pgsql-bugs@lists.postgresql.org
Subject: Re: VS: BUG #17218: Cluster recovery is not working properly.
In-Reply-To: <cd85e0d6cdcc4b4a9457172652a17df0@valtori.fi>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox