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 Tom Lane
Subject Re: pg_upgrade Only the install user can be defined in the new cluster
Date
Msg-id 3958121.1678991068@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_upgrade Only the install user can be defined in the new cluster  (Dávid Suchan <david.suchan@student.tuke.sk>)
Responses Re: pg_upgrade Only the install user can be defined in the new cluster
List pgsql-general
Tree view 
=?Windows-1252?Q?D=E1vid_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: Adrian Klaver
Date:
Subject: Re: Is the PL/pgSQL refcursor useful in a modern three-tier app?
Next
From: Daniel Gustafsson
Date:
Subject: Re: pg_upgrade Only the install user can be defined in the new cluster