It prints out:
count
-------
1
(1 row)Od: Daniel Gustafsson <daniel@xxxxxxxx>
Odoslané: streda 15. marca 2023 13:27 Komu: Dávid Suchan <david.suchan@xxxxxxxxxxxxxxx> Kópia: pgsql-general@xxxxxxxxxxxxxx <pgsql-general@xxxxxxxxxxxxxx> Predmet: Re: pg_upgrade Only the install user can be defined in the new cluster > On 15 Mar 2023, at 10:30, Dávid Suchan <david.suchan@xxxxxxxxxxxxxxx> wrote:
> ..there are no other users in the db. The check in question performs this: SELECT COUNT(*) FROM pg_catalog.pg_roles WHERE rolname !~ '^pg_'; What do you get when running that in the new v14 cluster? -- Daniel Gustafsson |