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

[Dávid Suchan <david.suchan@xxxxxxxxxxxxxxx>]

I installed both postgres versions on ubuntu machine with 'apt-get install postgres', which installed both client and server packages. Is that where I made a mistake?

---

Od: David G. Johnston <david.g.johnston@xxxxxxxxx>
Odoslané: pondelok 20. marca 2023 14:57
Komu: Dávid Suchan <david.suchan@xxxxxxxxxxxxxxx>
Kópia: Tom Lane <tgl@xxxxxxxxxxxxx>; Daniel Gustafsson <daniel@xxxxxxxx>; pgsql-general@xxxxxxxxxxxxxx <pgsql-general@xxxxxxxxxxxxxx>
Predmet: Re: pg_upgrade Only the install user can be defined in the new cluster

 

On Monday, March 20, 2023, Dávid Suchan <david.suchan@xxxxxxxxxxxxxxx> wrote:

 rolname

-----------

 anon

 api

 heartbeat

 postgres

only the default users..

You have an incorrect concept of default here.  Only postgres is installed by community PostgresSQL and thus pg_upgrade is rightfully complaining.

David J.