Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_upgrade Only the install user can be defined in the new cluster - Mailing list pgsql-general

From Dávid Suchan
Subject Re: pg_upgrade Only the install user can be defined in the new cluster
Date
Msg-id VE1P191MB1118C00F37452A13910F743BD6809@VE1P191MB1118.EURP191.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: pg_upgrade Only the install user can be defined in the new cluster  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_upgrade Only the install user can be defined in the new cluster  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
 rolname
-----------
 anon
 api
 heartbeat
 postgres

only the default users..
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_';

on the new cluster?

                        regards, tom lane

pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: NULL pg_database.datacl
Next
From: Erik Wienhold
Date:
Subject: Re: NULL pg_database.datacl