|
rolname
-----------
anon
api
heartbeat
postgres
only the default users..
Od: Tom Lane <tgl@xxxxxxxxxxxxx>
Odoslané: štvrtok 16. marca 2023 19:24 Komu: Dávid Suchan <david.suchan@xxxxxxxxxxxxxxx> Kópia: Daniel Gustafsson <daniel@xxxxxxxx>; pgsql-general@xxxxxxxxxxxxxx <pgsql-general@xxxxxxxxxxxxxx> Predmet: Re: pg_upgrade Only the install user can be defined in the new cluster =?Windows-1252?Q?D=E1vid_Suchan?= <david.suchan@xxxxxxxxxxxxxxx> writes:
> The ' SELECT COUNT(*) FROM pg_catalog.pg_roles WHERE rolname !~ '^pg_'; ' prints count 4 4? That would be the problem all right. What are those, that is what do you get from SELECT rolname FROM pg_catalog.pg_roles WHERE rolname !~ '^pg_'; on the new cluster? regards, tom lane |
