From: Paul Förster <paul.foerster@gmail.com>
To: Peter J. Holzer <hjp-pgsql@hjp.at>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: pg_checksums?
Date: Sun, 29 Oct 2023 16:15:37 +0100
Message-ID: <4614561A-6176-4136-BA96-74B05A7B6B5C@gmail.com> (raw)
In-Reply-To: <20231029104911.dj73ivozabdr5or4@hjp.at>
References: <22272207-E6E5-4DD5-9BD4-5F6B647E2C3B@gmail.com>
<0D18D31E-EF52-434D-875C-08BEC8DDD553@yesql.se>
<ZTwpx1sCIu-4EgRH@momjian.us>
<AB7D1C87-F9E6-4068-9AA9-8591C82CF9CC@gmail.com>
<20231029014310.7pbdfhincj2tds4l@hjp.at>
<81D43A87-7D3D-4F81-B462-641F15B5E332@gmail.com>
<20231029104911.dj73ivozabdr5or4@hjp.at>
Hi Peter,
> On Oct 29, 2023, at 11:49, Peter J. Holzer <hjp-pgsql@hjp.at> wrote:
>
> It *might* work if there are zero writes on the primary during the
> downtime of the replica (because those writes couldn't be replicated),
> but that seems hard to ensure. Even if you could get away with making
> the primary read-only (is this even possible?) I wouldn't have much
> confidence in the result and reinit the (new) replica anyway.
As soon as I stop the replica to enable checksums, even writes can't get replicated anymore. So during enabling checksums, a replica is definitely protected against modifications by its primary, simply because it's down. The modifications of the primary are applied to the replica when it comes back online. So, I don't see a problem at this particular stage.
My fear is merely that enabling checksums does something to the physical state of the data files which are not compatible with the other side. Like for example manipulate the file headers in some way.
Maybe this question is better suited for the admin list than this general list?
Cheers
Paul
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: paul.foerster@gmail.com, hjp-pgsql@hjp.at
Subject: Re: pg_checksums?
In-Reply-To: <4614561A-6176-4136-BA96-74B05A7B6B5C@gmail.com>
References: <22272207-E6E5-4DD5-9BD4-5F6B647E2C3B@gmail.com> <0D18D31E-EF52-434D-875C-08BEC8DDD553@yesql.se> <ZTwpx1sCIu-4EgRH@momjian.us> <AB7D1C87-F9E6-4068-9AA9-8591C82CF9CC@gmail.com> <20231029014310.7pbdfhincj2tds4l@hjp.at> <81D43A87-7D3D-4F81-B462-641F15B5E332@gmail.com> <20231029104911.dj73ivozabdr5or4@hjp.at> <4614561A-6176-4136-BA96-74B05A7B6B5C@gmail.com>
* 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