pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Paquier <michael@paquier.xyz>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Prevent startup of logical replication launcher during pg_upgrad
Date: Thu, 02 Nov 2023 05:35:06 +0000
Message-ID: <E1qyQMD-003XXN-Mf@gemulon.postgresql.org> (raw)

Prevent startup of logical replication launcher during pg_upgrade

The logical replication launcher may start apply workers during an
upgrade.  This could be the cause of corruptions on a new cluster if
these are able to apply changes before the physical files are copied
over to the new cluster.

The chance of being able to do so is small as pg_upgrade uses its own
port and unix domain directory (the latter is customizable with
--socketdir), but just preventing the launcher to start is safer at the
end, because we are then sure that no changes will be applied.  Like
29d0a77fa660 for max_slot_wal_keep_size, this is only set when a cluster
uses v17 or newer.

Author: Vignesh C
Discussion: https://postgr.es/m/CALDaNm2g9ZKf=y8X6z6MsLCuh8WwU-=Q6pLj35NFi2M5BZNS_A@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/7021d3b1766420ac4968fa0ff81873e81b7fd641

Modified Files
--------------
src/bin/pg_upgrade/server.c | 10 +++++++++-
1 file changed, 9 insertions(+), 1 deletion(-)



Message-ID: <E1qyQMD-003XXN-Mf@gemulon.postgresql.org>
Permalink:  ../E1qyQMD-003XXN-Mf@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1qyQMD-003XXN-Mf@gemulon.postgresql.org

 · 

reply

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-committers@postgresql.org
  Cc: michael@paquier.xyz, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Prevent startup of logical replication launcher during pg_upgrad
  In-Reply-To: <E1qyQMD-003XXN-Mf@gemulon.postgresql.org>

* 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