From: | Dávid Suchan <david(dot)suchan(at)student(dot)tuke(dot)sk> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Daniel Gustafsson <daniel(at)yesql(dot)se>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_upgrade Only the install user can be defined in the new cluster |
Date: | 2023-03-20 11:58:34 |
Message-ID: | VE1P191MB1118C00F37452A13910F743BD6809@VE1P191MB1118.EURP191.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
rolname
-----------
anon
api
heartbeat
postgres
only the default users..
________________________________
Od: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Odoslané: štvrtok 16. marca 2023 19:24
Komu: Dávid Suchan <david(dot)suchan(at)student(dot)tuke(dot)sk>
Kópia: Daniel Gustafsson <daniel(at)yesql(dot)se>; pgsql-general(at)postgresql(dot)org <pgsql-general(at)postgresql(dot)org>
Predmet: Re: pg_upgrade Only the install user can be defined in the new cluster
=?Windows-1252?Q?D=E1vid_Suchan?= <david(dot)suchan(at)student(dot)tuke(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Wienhold | 2023-03-20 12:18:56 | Re: NULL pg_database.datacl |
Previous Message | Dominique Devienne | 2023-03-20 10:52:52 | NULL pg_database.datacl |