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 Daniel Gustafsson
Subject Re: pg_upgrade Only the install user can be defined in the new cluster
Date
Msg-id 667112E0-5A1C-4F74-86F8-54B121C2336C@yesql.se
Whole thread Raw
In response to 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  (Dávid Suchan <david.suchan@student.tuke.sk>)
List pgsql-general
Tree view 
> On 15 Mar 2023, at 10:30, Dávid Suchan <david.suchan@student.tuke.sk> wrote:

> ..there are no other users in the db.

The check in question performs this:

    SELECT COUNT(*) FROM pg_catalog.pg_roles WHERE rolname !~ '^pg_';

What do you get when running that in the new v14 cluster?

--
Daniel Gustafsson

pgsql-general by date:

Previous
From: Dávid Suchan
Date:
Subject: pg_upgrade Only the install user can be defined in the new cluster
Next
From: Dávid Suchan
Date:
Subject: Re: pg_upgrade Only the install user can be defined in the new cluster