rolname
-----------
 anon
 api
 heartbeat
 postgres

only the default users..
________________________________
Od: Tom Lane <[email protected]>
Odoslané: štvrtok 16. marca 2023 19:24
Komu: Dávid Suchan <[email protected]>
Kópia: Daniel Gustafsson <[email protected]>; [email protected] 
<[email protected]>
Predmet: Re: pg_upgrade Only the install user can be defined in the new cluster

=?Windows-1252?Q?D=E1vid_Suchan?= <[email protected]> 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

Reply via email to