Re: pg_upgrade Only the install user can be defined in the new cluster

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dávid Suchan <david(dot)suchan(at)student(dot)tuke(dot)sk>
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-16 18:24:28
Message-ID: 3958121.1678991068@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Gustafsson 2023-03-16 19:14:43 Re: pg_upgrade Only the install user can be defined in the new cluster
Previous Message Adrian Klaver 2023-03-16 17:05:01 Re: Is the PL/pgSQL refcursor useful in a modern three-tier app?