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
