MIME-Version: 1.0
References: <CAAV-98-1cytHJLYVWXjOihwueOj_VQn9nrA3EWe91AymV354xg@mail.gmail.com>
 <202511201242.4pht5cyc33ex@alvherre.pgsql>
In-Reply-To: <202511201242.4pht5cyc33ex@alvherre.pgsql>
From: Hu Bert <revirii@googlemail.com>
Date: Thu, 20 Nov 2025 13:57:33 +0100
Message-ID: <CAAV-98_Ug_nQmdC8bxDMjKBJdn7H5KUdGyMYbPsOaS6Odmt=iQ@mail.gmail.com>
Subject: Re: postgresql-17 on debian bookworm - directories missing
To: =?UTF-8?Q?=C3=81lvaro_Herrera?= <alvherre@kurilemu.de>
Cc: pgsql-general@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAAV-98_Ug_nQmdC8bxDMjKBJdn7H5KUdGyMYbPsOaS6Odmt%3DiQ%40mail.gmail.com>
Precedence: bulk

Hi =C3=81lvaro,

interesting - about one and a half year ago i upgraded postgresql from
14 to 16 - installed the v16 packages, and both versions and two
clusters were running.

upgrade:
/usr/lib/postgresql/16/bin/pg_upgrade --link --old-options "-c
config_file=3D/etc/postgresql/14/main/postgresql.conf" --new-options "-c
config_file=3D/etc/postgresql/16/main/postgresql.conf"
--old-bindir=3D/usr/lib/postgresql/14/bin/
--new-bindir=3D/usr/lib/postgresql/16/bin/
--old-datadir=3D/var/lib/postgresql/14/main
--new-datadir=3D/var/lib/postgresql/16/main --old-port=3D5432
--new-port=3D5433

So that must've changed in the past. However... so i have 2 options:

- create a v17 cluster and run pg_upgrade or
- run pg_upgradecluster

Have to check the 2nd command :-)

Thx,
Hubert

Am Do., 20. Nov. 2025 um 13:46 Uhr schrieb =C3=81lvaro Herrera
<alvherre@kurilemu.de>:
>
> On 2025-Nov-20, Hu Bert wrote:
>
> > Hi there,
> > i have a debian bookworm with postgresql-16 installed, from postgresql
> > repository. I wanted to install postgresql-17 and then do a an inplace
> > upgrade via pg_upgrade.
> >
> > Install: apt install postgresql-17 postgresql-17-postgis-3
> > postgresql-17-postgis-3-scripts postgresql-client-17
> >
> > But after the installation there's no v17 cluster:
>
> I think this is expected.  The Debian packages create a cluster when you
> install the server packages only if you don't already have a cluster.
> Here it's clearly that you do have one, so a new one isn't created.  You
> could create one yourself with pg_createcluster.  However, if what you
> want to do is to upgrade the 16 one, then I think you don't need to
> create a new one, but instead use pg_upgradecluster which will create
> one for you.
>
> --
> =C3=81lvaro Herrera               48=C2=B001'N 7=C2=B057'E  =E2=80=94  ht=
tps://www.EnterpriseDB.com/