pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Thorsten Glaser <tg@evolvis.org>
To: Dávid Suchan <david.suchan@student.tuke.sk>
Cc: pgsql-general@postgresql.org
Subject: Re: pg_upgrade Only the install user can be defined in the new cluster
Date: Mon, 20 Mar 2023 15:20:47 +0100 (CET)
Message-ID: <a95056f2-cb5c-4bbb-aec5-76cc291869f5@evolvis.org> (raw)
In-Reply-To: <CAKFQuwZ3YMLOvBfpBKdk-ae7OTy3kUv7ZFDt+YA8v9+e90es8g@mail.gmail.com>
References: <VE1P191MB1118E9752D4EAD45205E995CD6BF9@VE1P191MB1118.EURP191.PROD.OUTLOOK.COM>
	<667112E0-5A1C-4F74-86F8-54B121C2336C@yesql.se>
	<VE1P191MB1118026DEE572DFB06D0AA1ED6BF9@VE1P191MB1118.EURP191.PROD.OUTLOOK.COM>
	<021ED6C2-C01F-4E5B-8415-10C1BE29FCBA@yesql.se>
	<VE1P191MB111805B6886F6AD3E78E620BD6BC9@VE1P191MB1118.EURP191.PROD.OUTLOOK.COM>
	<3958121.1678991068@sss.pgh.pa.us>
	<VE1P191MB1118C00F37452A13910F743BD6809@VE1P191MB1118.EURP191.PROD.OUTLOOK.COM>
	<CAKFQuwZMdF-0hfJ2umSfXuW860KbOoqt5+STs3LeyZWNQ+hb-g@mail.gmail.com>
	<VE1P191MB11181B9D015C3B89C0D4966FD6809@VE1P191MB1118.EURP191.PROD.OUTLOOK.COM>
	<CAKFQuwZ3YMLOvBfpBKdk-ae7OTy3kUv7ZFDt+YA8v9+e90es8g@mail.gmail.com>

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

>On Monday, March 20, 2023, Dávid Suchan <david.suchan@student.tuke.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 :-)





view thread (14+ messages)

Message-ID: <a95056f2-cb5c-4bbb-aec5-76cc291869f5@evolvis.org>
Permalink:  ../a95056f2-cb5c-4bbb-aec5-76cc291869f5@evolvis.org/
Also on:    postgresql.org/message-id/a95056f2-cb5c-4bbb-aec5-76cc291869f5@evolvis.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: tg@evolvis.org, david.suchan@student.tuke.sk
  Subject: Re: pg_upgrade Only the install user can be defined in the new cluster
  In-Reply-To: <a95056f2-cb5c-4bbb-aec5-76cc291869f5@evolvis.org>
  References: <VE1P191MB1118E9752D4EAD45205E995CD6BF9@VE1P191MB1118.EURP191.PROD.OUTLOOK.COM> <667112E0-5A1C-4F74-86F8-54B121C2336C@yesql.se> <VE1P191MB1118026DEE572DFB06D0AA1ED6BF9@VE1P191MB1118.EURP191.PROD.OUTLOOK.COM> <021ED6C2-C01F-4E5B-8415-10C1BE29FCBA@yesql.se> <VE1P191MB111805B6886F6AD3E78E620BD6BC9@VE1P191MB1118.EURP191.PROD.OUTLOOK.COM> <3958121.1678991068@sss.pgh.pa.us> <VE1P191MB1118C00F37452A13910F743BD6809@VE1P191MB1118.EURP191.PROD.OUTLOOK.COM> <CAKFQuwZMdF-0hfJ2umSfXuW860KbOoqt5+STs3LeyZWNQ+hb-g@mail.gmail.com> <VE1P191MB11181B9D015C3B89C0D4966FD6809@VE1P191MB1118.EURP191.PROD.OUTLOOK.COM> <CAKFQuwZ3YMLOvBfpBKdk-ae7OTy3kUv7ZFDt+YA8v9+e90es8g@mail.gmail.com> <a95056f2-cb5c-4bbb-aec5-76cc291869f5@evolvis.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox