Od: Tom Lane <tgl@sss.pgh.pa.us> Odoslané: štvrtok 16. marca 2023 19:24 Komu: Dávid Suchan <david.suchan@student.tuke.sk> Kópia: Daniel Gustafsson <daniel@yesql.se>; pgsql-general@postgresql.org <pgsql-general@postgresql.org> Predmet: Re: pg_upgrade Only the install user can be defined in the new cluster
Dávid Suchan <david.suchan@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_';