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: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Daniel Gustafsson <daniel(at)yesql(dot)se>, "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-20 14:02:43
Message-ID: VE1P191MB11181B9D015C3B89C0D4966FD6809@VE1P191MB1118.EURP191.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)g(dot)johnston(at)gmail(dot)com>
Odoslané: pondelok 20. marca 2023 14:57
Komu: Dávid Suchan <david(dot)suchan(at)student(dot)tuke(dot)sk>
Kópia: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>; Daniel Gustafsson <daniel(at)yesql(dot)se>; 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 Monday, March 20, 2023, Dávid Suchan <david(dot)suchan(at)student(dot)tuke(dot)sk<mailto:david(dot)suchan(at)student(dot)tuke(dot)sk>> 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2023-03-20 14:08:36 Re: pg_upgrade Only the install user can be defined in the new cluster
Previous Message David G. Johnston 2023-03-20 13:57:51 Re: pg_upgrade Only the install user can be defined in the new cluster