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@yesql.se>
Odoslané: štvrtok 16. marca 2023 10:28
Komu: Dávid Suchan <david.suchan@student.tuke.sk>
Kópia: pgsql-general@postgresql.org <pgsql-general@postgresql.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.suchan@student.tuke.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
