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

From: Dávid Suchan <david(dot)suchan(at)student(dot)tuke(dot)sk>
To: Daniel Gustafsson <daniel(at)yesql(dot)se>
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-16 14:56:48
Message-ID: VE1P191MB111805B6886F6AD3E78E620BD6BC9@VE1P191MB1118.EURP191.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

So I tried upgrading into this brand new cluster I created(using initdb -D /somedatapathichose). Running the upgrade with --check worked, it returned message that the clusters are identical. Then I stopped the new cluster, and ran the pg_upgrade without --check, which resulted in another:
Checking database user is the install user
Only the install user can be defined in the new cluster.
Failure, exiting
I dont know what to check for anymore, the log files dont say anything other than "Only the install user can be defined in the new cluster" when postgres is the install user everywhere.
The ' SELECT COUNT(*) FROM pg_catalog.pg_roles WHERE rolname !~ '^pg_'; ' prints count 4 and ' SELECT rolname FROM pg_roles WHERE oid = 10; ' prints rolname postgres.
________________________________
Od: Daniel Gustafsson <daniel(at)yesql(dot)se>
Odoslané: štvrtok 16. marca 2023 10:28
Komu: Dávid Suchan <david(dot)suchan(at)student(dot)tuke(dot)sk>
Kópia: pgsql-general(at)postgresql(dot)org <pgsql-general(at)postgresql(dot)org>
Predmet: Re: pg_upgrade Only the install user can be defined in the new cluster

> On 15 Mar 2023, at 16:39, Dávid Suchan <david(dot)suchan(at)student(dot)tuke(dot)sk> wrote:
>
> It prints out:
> count
> -------
> 1

I have a feeling the cluster you tried to upgrade to doesn't match this one, as
the check that failed will fail on values other than 1. Did you create them
equally? If you try to upgrade into this cluster, even just with the --check
option, does that yield more success?

--
Daniel Gustafsson

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2023-03-16 17:05:01 Re: Is the PL/pgSQL refcursor useful in a modern three-tier app?
Previous Message Mark Hill 2023-03-16 13:31:03 FW: uuid-ossp source or binaries for Windows