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

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Dávid Suchan <david(dot)suchan(at)student(dot)tuke(dot)sk>
Cc: "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-15 12:27:20
Message-ID: 667112E0-5A1C-4F74-86F8-54B121C2336C@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On 15 Mar 2023, at 10:30, Dávid Suchan <david(dot)suchan(at)student(dot)tuke(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dávid Suchan 2023-03-15 13:48:06 Re: pg_upgrade Only the install user can be defined in the new cluster
Previous Message Dávid Suchan 2023-03-15 09:30:15 pg_upgrade Only the install user can be defined in the new cluster