Re: Postgres upgrade does not mention requirement to have only 1 user

2021-01-26 Thread Charlie Hayes
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,

Re: Postgres upgrade does not mention requirement to have only 1 user

2021-01-26 Thread Bruce Momjian
On Tue, Jan 26, 2021 at 10:27:23AM +0100, Daniel Gustafsson wrote: > > On 26 Jan 2021, at 09:39, Laurenz Albe wrote: > > > 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." > > +

Re: Postgres upgrade does not mention requirement to have only 1 user

2021-01-26 Thread Daniel Gustafsson
> On 26 Jan 2021, at 09:39, Laurenz Albe wrote: > 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." +1, that makes sense (with a s/and/any/). -- Daniel Gustafsson https:

Re: Postgres upgrade does not mention requirement to have only 1 user

2021-01-26 Thread Laurenz Albe
On Tue, 2021-01-26 at 06:57 +, 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

Re: Postgres upgrade does not mention requirement to have only 1 user

2021-01-26 Thread Charlie Hayes
I see now that the user check was verifying the target database and not the source. My upgrade script (which I used from 11 to 12) initialized the target database for upgrades as it did for seeding from scratch which included a user account. I removed that part of the script and the upgrade comp

Postgres upgrade does not mention requirement to have only 1 user

2021-01-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: 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