rolname
-----------
anon
api
heartbeat
postgres
only the default users..
________________________________
Od: Tom Lane <t...@sss.pgh.pa.us>
Odoslané: štvrtok 16. marca 2023 19:24
Komu: Dávid Suchan <david.suc...@student.tuke.sk>
Kópia: Daniel Gustafsson <dan...@yesql.se>; pgsql-gene...@postgresql.org
<pgsql-gene...@postgresql.org>
Predmet: Re: pg_upgrade Only the install user can be defined in the new cluster
=?Windows-1252?Q?D=E1vid_Suchan?= <david.suc...@student.tuke.sk> 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
