From: Tom Lane <tgl@sss.pgh.pa.us>
To: mathiaskunter@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17347: pg_upgrade: analyze_new_cluster script analyzes wrong cluster
Date: Tue, 28 Dec 2021 11:00:35 -0500
Message-ID: <1760674.1640707235@sss.pgh.pa.us> (raw)
In-Reply-To: <17347-27b988f51d9dee1a@postgresql.org>
References: <17347-27b988f51d9dee1a@postgresql.org>
PG Bug reporting form <noreply@postgresql.org> writes:
> When upgrading a PostgreSQL cluster with pg_upgrade (tested while upgrading
> from 11.14 to 12.9, but supposedly affects all versions), and the --new-port
> argument is used to specify a new port number for the upgraded cluster, then
> the generated analyze_new_cluster script will connect to and analyze a
> different cluster instead of the upgraded one.
> The vacuumdb command found within the analyze_new_cluster script should
> explicitly specify the port number of the upgraded cluster, so that it will
> actually analyze the correct cluster after the upgrade.
Hmm. I'm not sure whether changing that would be an improvement.
The assumption you're making is that --new-port will be the new
cluster's port number after it's started for real. But it seems
at least as likely that it's just a nonce specification used for
long enough to finish sucking data out of your old cluster, and
then you'll start the new server in place of your old one (ie
using the old port).
It's a bit moot now anyway, since pg_upgrade doesn't create
that script anymore in v14 and up.
regards, tom lane
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: tgl@sss.pgh.pa.us, mathiaskunter@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17347: pg_upgrade: analyze_new_cluster script analyzes wrong cluster
In-Reply-To: <1760674.1640707235@sss.pgh.pa.us>
* 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