From: Charlie Hayes <ce.ceo@cybercoment.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: Postgres upgrade does not mention requirement to have only 1 user
Date: Tue, 26 Jan 2021 11:16:20 -0600
Message-ID: <2AA2F2BC-FD29-49ED-BCF1-937E4192E54F@cybercoment.com> (raw)
In-Reply-To: <eced44db1c20de9cdce0dcd6b7922a113d3728a2.camel@cybertec.at>
References: <161164427375.4070.1378381620788426246@wrigleys.postgresql.org>
<eced44db1c20de9cdce0dcd6b7922a113d3728a2.camel@cybertec.at>
It may say “in the new cluster” but it was not clear to me if that was “in the new cluster (before the upgrade starts)” or “in the new cluster (after the upgrade completes)”
In hind sight everything makes sense, but in the present it was very confusing.
-Charlie
> On Jan 26, 2021, at 2:39 AM, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>
> On Tue, 2021-01-26 at 06:57 +0000, PG Doc comments form wrote:
>> Page: https://www.postgresql.org/docs/13/pgupgrade.html
>> Description:
>>
>> During the pg_upgrade process, a check is run to make sure
>> pg_catalog.pg_roles has only a single non pg_* user, typically this is just
>> 'postgres'. If this check fails, the error message is "Only the install user
>> can be defined in the new cluster."; This message implies the user executing
>> pg_upgrade must match the the rolsuper in pg_catalog.pg_roles.
>>
>> There's no indication in the documentation that the user table must be
>> flushed of all but the one user, nor does it prescribe a method to move
>> forward. The error message is not helpful; I only figured it out by finding
>> and reading the postgres source code.
>
> The error message says "in the new cluster".
>
> The documentation says, "Initialize the new PostgreSQL cluster" and that there
> is no need to start the cluster. That is a pretty strong indication that it
> is not necessary to create any objects there.
>
> But perhaps it would not harm to be more explicit and add something like
> that:
>
> "Do not create and users, tablespaces or other objects on the new cluster."
>
> Yours,
> Laurenz Albe
>
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-docs@postgresql.org
Cc: ce.ceo@cybercoment.com, laurenz.albe@cybertec.at, pgsql-docs@lists.postgresql.org
Subject: Re: Postgres upgrade does not mention requirement to have only 1 user
In-Reply-To: <2AA2F2BC-FD29-49ED-BCF1-937E4192E54F@cybercoment.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