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

From: Thorsten Glaser <tg(at)evolvis(dot)org>
To: Dávid Suchan <david(dot)suchan(at)student(dot)tuke(dot)sk>
Cc: 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:20:47
Message-ID: a95056f2-cb5c-4bbb-aec5-76cc291869f5@evolvis.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 20 Mar 2023, David G. Johnston wrote:

>On Monday, March 20, 2023, Dávid Suchan <david(dot)suchan(at)student(dot)tuke(dot)sk>
>wrote:
>
>> 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?

>Anyway, you had to have done more than that to use those other roles to
>appear in the new cluster.

And the Debian instructions are pretty clear, they tell one to
first drop the new version’s per-default-installed cluster then
upgrade the old cluster (into a fresh new one).

bye,
//mirabilos
--
15:41⎜<Lo-lan-do:#fusionforge> Somebody write a testsuite for helloworld :-)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2023-03-20 14:21:39 Re: Oracle to PostgreSQL Migration
Previous Message Ron Johnson 2023-03-20 14:15:25 Re: Oracle to PostgreSQL Migration