public inbox for [email protected]
help / color / mirror / Atom feedInstalling multiple Postgresql Versions in parallel, does not seem to work anymore
2+ messages / 2 participants
[nested] [flat]
* Installing multiple Postgresql Versions in parallel, does not seem to work anymore
@ 2025-12-14 15:58 Simon Hönscheid <[email protected]>
2025-12-14 18:55 ` Re: Installing multiple Postgresql Versions in parallel, does not seem to work anymore Christoph Berg <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Simon Hönscheid @ 2025-12-14 15:58 UTC (permalink / raw)
To: pgsql-pkg-debian
Hello Listmembers,
during a routine postgresql upgrade from 14 to 17 on a Debian 12 Server
I stumbled over this behaviour:
The Server is Running Debian 12 and the postgresql.org apt repository.
Until today the Server was running Postgresql 14 and an upgrade to
postgresql 17 was planned. In the past I used to install the new version
in parallel and migrated the data. Today I noticecd the post install
steps did not run. No cluster was bootstrapped, no config directory
created, no systemd unit created. There was also an upgrade planned to
Debian 13, so I did this first, and tried again. Same result.
I confirmed on a fresh Debian 13 server and the result is the same.
Please find the console log of the fresh Debian 13 Server attached.
Kind Regards,
Simon
--
Simon Hönscheid
Berater und Systemarchitekt für Automatisierung, Cloud & Monitoring
Xyntion GmbH
Genter Straße 12
13353 Berlin
Geschäftsführer: Simon Hönscheid
HRB 263949 B - Amtsgericht Charlottenburg
Mobil: +49 (0)163-48 24 220
Email:[email protected]
Web:https://www.xyntion.consulting
root@postgres-testserver:~# apt update
[...]
root@postgres-testserver:~# apt install -y postgresql-common
Installing:
postgresql-common
Installing dependencies:
libgdbm-compat4t64 libio-pty-perl libipc-run-perl libjson-perl libperl5.40 perl perl-modules-5.40 postgresql-client-common postgresql-common-dev ssl-cert
Suggested packages:
perl-doc libterm-readline-gnu-perl | libterm-readline-perl-perl make libtap-harness-archive-perl
Recommended packages:
libjson-xs-perl
Summary:
Upgrading: 0, Installing: 11, Removing: 0, Not Upgrading: 38
Download size: 8,149 kB
Space needed: 53.0 MB / 36.9 GB available
Get:1 <http://deb.debian.org/debian; trixie/main amd64 perl-modules-5.40 all 5.40.1-6 [3,019 kB]
Get:2 <http://deb.debian.org/debian; trixie/main amd64 libgdbm-compat4t64 amd64 1.24-2 [50.3 kB]
Get:3 <http://deb.debian.org/debian; trixie/main amd64 libperl5.40 amd64 5.40.1-6 [4,341 kB]
Get:4 <http://deb.debian.org/debian; trixie/main amd64 perl amd64 5.40.1-6 [267 kB]
Get:5 <http://deb.debian.org/debian; trixie/main amd64 libjson-perl all 4.10000-1 [87.5 kB]
Get:6 <http://deb.debian.org/debian; trixie/main amd64 postgresql-client-common all 278 [47.1 kB]
Get:7 <http://deb.debian.org/debian; trixie/main amd64 libio-pty-perl amd64 1:1.20-1+b3 [34.3 kB]
Get:8 <http://deb.debian.org/debian; trixie/main amd64 libipc-run-perl all 20231003.0-2 [101 kB]
Get:9 <http://deb.debian.org/debian; trixie/main amd64 postgresql-common-dev all 278 [72.4 kB]
Get:10 <http://deb.debian.org/debian; trixie/main amd64 ssl-cert all 1.1.3 [16.8 kB]
Get:11 <http://deb.debian.org/debian; trixie/main amd64 postgresql-common all 278 [112 kB]
Fetched 8,149 kB in 0s (55.5 MB/s)
Preconfiguring packages ...
Selecting previously unselected package perl-modules-5.40.
(Reading database ... 34000 files and directories currently installed.)
Preparing to unpack .../00-perl-modules-5.40_5.40.1-6_all.deb ...
Unpacking perl-modules-5.40 (5.40.1-6) ...
Selecting previously unselected package libgdbm-compat4t64:amd64.
Preparing to unpack .../01-libgdbm-compat4t64_1.24-2_amd64.deb ...
Unpacking libgdbm-compat4t64:amd64 (1.24-2) ...
Selecting previously unselected package libperl5.40:amd64.
Preparing to unpack .../02-libperl5.40_5.40.1-6_amd64.deb ...
Unpacking libperl5.40:amd64 (5.40.1-6) ...
Selecting previously unselected package perl.
Preparing to unpack .../03-perl_5.40.1-6_amd64.deb ...
Unpacking perl (5.40.1-6) ...
Selecting previously unselected package libjson-perl.
Preparing to unpack .../04-libjson-perl_4.10000-1_all.deb ...
Unpacking libjson-perl (4.10000-1) ...
Selecting previously unselected package postgresql-client-common.
Preparing to unpack .../05-postgresql-client-common_278_all.deb ...
Unpacking postgresql-client-common (278) ...
Selecting previously unselected package libio-pty-perl.
Preparing to unpack .../06-libio-pty-perl_1%3a1.20-1+b3_amd64.deb ...
Unpacking libio-pty-perl (1:1.20-1+b3) ...
Selecting previously unselected package libipc-run-perl.
Preparing to unpack .../07-libipc-run-perl_20231003.0-2_all.deb ...
Unpacking libipc-run-perl (20231003.0-2) ...
Selecting previously unselected package postgresql-common-dev.
Preparing to unpack .../08-postgresql-common-dev_278_all.deb ...
Unpacking postgresql-common-dev (278) ...
Selecting previously unselected package ssl-cert.
Preparing to unpack .../09-ssl-cert_1.1.3_all.deb ...
Unpacking ssl-cert (1.1.3) ...
Selecting previously unselected package postgresql-common.
Preparing to unpack .../10-postgresql-common_278_all.deb ...
Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'
Unpacking postgresql-common (278) ...
Setting up libgdbm-compat4t64:amd64 (1.24-2) ...
Setting up ssl-cert (1.1.3) ...
Setting up perl-modules-5.40 (5.40.1-6) ...
Setting up libperl5.40:amd64 (5.40.1-6) ...
Setting up perl (5.40.1-6) ...
Setting up libjson-perl (4.10000-1) ...
Setting up postgresql-client-common (278) ...
Setting up libio-pty-perl (1:1.20-1+b3) ...
Setting up libipc-run-perl (20231003.0-2) ...
Setting up postgresql-common-dev (278) ...
Setting up postgresql-common (278) ...
Creating config file /etc/postgresql-common/createcluster.conf with new version
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'.
Processing triggers for man-db (2.13.1-1) ...
Processing triggers for libc-bin (2.41-12) ...
root@postgres-testserver:~# sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh
This script will enable the PostgreSQL APT repository on apt.postgresql.org on
your system. The distribution codename used will be trixie-pgdg.
Press Enter to continue, or Ctrl-C to abort.
Using keyring /usr/share/postgresql-common/pgdg/apt.postgresql.org.gpg
Writing /etc/apt/sources.list.d/pgdg.sources ...
Running apt-get update ...
Hit:1 <http://deb.debian.org/debian; trixie InRelease
Hit:2 <http://deb.debian.org/debian; trixie-updates InRelease
Hit:3 <http://mirror.hetzner.com/debian/packages; trixie InRelease
Get:4 <https://apt.postgresql.org/pub/repos/apt; trixie-pgdg InRelease [107 kB]
Hit:5 <http://mirror.hetzner.com/debian/packages; trixie-updates InRelease
Hit:6 <http://deb.debian.org/debian; trixie-backports InRelease
Hit:7 <http://deb.debian.org/debian-security; trixie-security InRelease
Hit:8 <http://mirror.hetzner.com/debian/packages; trixie-backports InRelease
Hit:9 <http://mirror.hetzner.com/debian/security; trixie-security InRelease
Get:10 <https://apt.postgresql.org/pub/repos/apt; trixie-pgdg/main amd64 Packages [351 kB]
Fetched 457 kB in 0s (966 kB/s)
Reading package lists... Done
You can now start installing packages from apt.postgresql.org.
Have a look at <https://wiki.postgresql.org/wiki/Apt; for more information;
most notably the FAQ at <https://wiki.postgresql.org/wiki/Apt/FAQ;
root@postgres-testserver:~# sudo apt install postgresql-14
Installing:
postgresql-14
Installing dependencies:
libllvm19 libpq5 libxslt1.1 libz3-4 postgresql-client-14
Suggested packages:
libpq-oauth postgresql-doc-14
Recommended packages:
sysstat
Summary:
Upgrading: 0, Installing: 6, Removing: 0, Not Upgrading: 41
Download size: 51.2 MB
Space needed: 216 MB / 36.9 GB available
Continue? [Y/n] y
Get:1 <http://deb.debian.org/debian; trixie/main amd64 libz3-4 amd64 4.13.3-1 [8,560 kB]
Get:2 <https://apt.postgresql.org/pub/repos/apt; trixie-pgdg/main amd64 libpq5 amd64 18.1-1.pgdg13+2 [248 kB]
Get:3 <http://deb.debian.org/debian; trixie/main amd64 libllvm19 amd64 1:19.1.7-3+b1 [26.0 MB]
Get:4 <https://apt.postgresql.org/pub/repos/apt; trixie-pgdg/main amd64 postgresql-client-14 amd64 14.20-1.pgdg13+1 [1,683 kB]
Get:5 <https://apt.postgresql.org/pub/repos/apt; trixie-pgdg/main amd64 postgresql-14 amd64 14.20-1.pgdg13+1 [14.5 MB]
Get:6 <http://deb.debian.org/debian; trixie/main amd64 libxslt1.1 amd64 1.1.35-1.2+deb13u2 [233 kB]
Fetched 51.2 MB in 1s (53.4 MB/s)
Preconfiguring packages ...
Selecting previously unselected package libz3-4:amd64.
(Reading database ... 36428 files and directories currently installed.)
Preparing to unpack .../0-libz3-4_4.13.3-1_amd64.deb ...
Unpacking libz3-4:amd64 (4.13.3-1) ...
Selecting previously unselected package libllvm19:amd64.
Preparing to unpack .../1-libllvm19_1%3a19.1.7-3+b1_amd64.deb ...
Unpacking libllvm19:amd64 (1:19.1.7-3+b1) ...
Selecting previously unselected package libpq5:amd64.
Preparing to unpack .../2-libpq5_18.1-1.pgdg13+2_amd64.deb ...
Unpacking libpq5:amd64 (18.1-1.pgdg13+2) ...
Selecting previously unselected package libxslt1.1:amd64.
Preparing to unpack .../3-libxslt1.1_1.1.35-1.2+deb13u2_amd64.deb ...
Unpacking libxslt1.1:amd64 (1.1.35-1.2+deb13u2) ...
Selecting previously unselected package postgresql-client-14.
Preparing to unpack .../4-postgresql-client-14_14.20-1.pgdg13+1_amd64.deb ...
Unpacking postgresql-client-14 (14.20-1.pgdg13+1) ...
Selecting previously unselected package postgresql-14.
Preparing to unpack .../5-postgresql-14_14.20-1.pgdg13+1_amd64.deb ...
Unpacking postgresql-14 (14.20-1.pgdg13+1) ...
Setting up libpq5:amd64 (18.1-1.pgdg13+2) ...
Setting up postgresql-client-14 (14.20-1.pgdg13+1) ...
update-alternatives: using /usr/share/postgresql/14/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up libz3-4:amd64 (4.13.3-1) ...
Setting up libxslt1.1:amd64 (1.1.35-1.2+deb13u2) ...
Setting up libllvm19:amd64 (1:19.1.7-3+b1) ...
Setting up postgresql-14 (14.20-1.pgdg13+1) ...
Creating new PostgreSQL cluster 14/main ...
/usr/lib/postgresql/14/bin/initdb -D /var/lib/postgresql/14/main --auth-local peer --auth-host scram-sha-256 --no-instructions
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /var/lib/postgresql/14/main ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
Processing triggers for postgresql-common (278) ...
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
Processing triggers for libc-bin (2.41-12) ...
root@postgres-testserver:~# sudo apt install postgresql-17
Installing:
postgresql-17
Installing dependencies:
postgresql-client-17
Suggested packages:
postgresql-doc-17
Recommended packages:
sysstat
Summary:
Upgrading: 0, Installing: 2, Removing: 0, Not Upgrading: 41
Download size: 18.6 MB
Space needed: 69.4 MB / 36.6 GB available
Continue? [Y/n]
Get:1 <https://apt.postgresql.org/pub/repos/apt; trixie-pgdg/main amd64 postgresql-client-17 amd64 17.7-3.pgdg13+1 [2,045 kB]
Get:2 <https://apt.postgresql.org/pub/repos/apt; trixie-pgdg/main amd64 postgresql-17 amd64 17.7-3.pgdg13+1 [16.6 MB]
Fetched 18.6 MB in 1s (33.7 MB/s)
Preconfiguring packages ...
Selecting previously unselected package postgresql-client-17.
(Reading database ... 38369 files and directories currently installed.)
Preparing to unpack .../postgresql-client-17_17.7-3.pgdg13+1_amd64.deb ...
Unpacking postgresql-client-17 (17.7-3.pgdg13+1) ...
Selecting previously unselected package postgresql-17.
Preparing to unpack .../postgresql-17_17.7-3.pgdg13+1_amd64.deb ...
Unpacking postgresql-17 (17.7-3.pgdg13+1) ...
Setting up postgresql-client-17 (17.7-3.pgdg13+1) ...
update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up postgresql-17 (17.7-3.pgdg13+1) ...
Processing triggers for postgresql-common (278) ...
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
root@postgres-testserver:~# ls -lah /etc/postgresql
total 12K
drwxr-xr-x 3 postgres postgres 4.0K Dec 14 15:32 .
drwxr-xr-x 78 root root 4.0K Dec 14 15:32 ..
drwxr-xr-x 3 postgres postgres 4.0K Dec 14 15:32 14
Attachments:
[text/plain] postgres-install.txt (11.3K, 3-postgres-install.txt)
download | inline:
root@postgres-testserver:~# apt update
[...]
root@postgres-testserver:~# apt install -y postgresql-common
Installing:
postgresql-common
Installing dependencies:
libgdbm-compat4t64 libio-pty-perl libipc-run-perl libjson-perl libperl5.40 perl perl-modules-5.40 postgresql-client-common postgresql-common-dev ssl-cert
Suggested packages:
perl-doc libterm-readline-gnu-perl | libterm-readline-perl-perl make libtap-harness-archive-perl
Recommended packages:
libjson-xs-perl
Summary:
Upgrading: 0, Installing: 11, Removing: 0, Not Upgrading: 38
Download size: 8,149 kB
Space needed: 53.0 MB / 36.9 GB available
Get:1 <http://deb.debian.org/debian> trixie/main amd64 perl-modules-5.40 all 5.40.1-6 [3,019 kB]
Get:2 <http://deb.debian.org/debian> trixie/main amd64 libgdbm-compat4t64 amd64 1.24-2 [50.3 kB]
Get:3 <http://deb.debian.org/debian> trixie/main amd64 libperl5.40 amd64 5.40.1-6 [4,341 kB]
Get:4 <http://deb.debian.org/debian> trixie/main amd64 perl amd64 5.40.1-6 [267 kB]
Get:5 <http://deb.debian.org/debian> trixie/main amd64 libjson-perl all 4.10000-1 [87.5 kB]
Get:6 <http://deb.debian.org/debian> trixie/main amd64 postgresql-client-common all 278 [47.1 kB]
Get:7 <http://deb.debian.org/debian> trixie/main amd64 libio-pty-perl amd64 1:1.20-1+b3 [34.3 kB]
Get:8 <http://deb.debian.org/debian> trixie/main amd64 libipc-run-perl all 20231003.0-2 [101 kB]
Get:9 <http://deb.debian.org/debian> trixie/main amd64 postgresql-common-dev all 278 [72.4 kB]
Get:10 <http://deb.debian.org/debian> trixie/main amd64 ssl-cert all 1.1.3 [16.8 kB]
Get:11 <http://deb.debian.org/debian> trixie/main amd64 postgresql-common all 278 [112 kB]
Fetched 8,149 kB in 0s (55.5 MB/s)
Preconfiguring packages ...
Selecting previously unselected package perl-modules-5.40.
(Reading database ... 34000 files and directories currently installed.)
Preparing to unpack .../00-perl-modules-5.40_5.40.1-6_all.deb ...
Unpacking perl-modules-5.40 (5.40.1-6) ...
Selecting previously unselected package libgdbm-compat4t64:amd64.
Preparing to unpack .../01-libgdbm-compat4t64_1.24-2_amd64.deb ...
Unpacking libgdbm-compat4t64:amd64 (1.24-2) ...
Selecting previously unselected package libperl5.40:amd64.
Preparing to unpack .../02-libperl5.40_5.40.1-6_amd64.deb ...
Unpacking libperl5.40:amd64 (5.40.1-6) ...
Selecting previously unselected package perl.
Preparing to unpack .../03-perl_5.40.1-6_amd64.deb ...
Unpacking perl (5.40.1-6) ...
Selecting previously unselected package libjson-perl.
Preparing to unpack .../04-libjson-perl_4.10000-1_all.deb ...
Unpacking libjson-perl (4.10000-1) ...
Selecting previously unselected package postgresql-client-common.
Preparing to unpack .../05-postgresql-client-common_278_all.deb ...
Unpacking postgresql-client-common (278) ...
Selecting previously unselected package libio-pty-perl.
Preparing to unpack .../06-libio-pty-perl_1%3a1.20-1+b3_amd64.deb ...
Unpacking libio-pty-perl (1:1.20-1+b3) ...
Selecting previously unselected package libipc-run-perl.
Preparing to unpack .../07-libipc-run-perl_20231003.0-2_all.deb ...
Unpacking libipc-run-perl (20231003.0-2) ...
Selecting previously unselected package postgresql-common-dev.
Preparing to unpack .../08-postgresql-common-dev_278_all.deb ...
Unpacking postgresql-common-dev (278) ...
Selecting previously unselected package ssl-cert.
Preparing to unpack .../09-ssl-cert_1.1.3_all.deb ...
Unpacking ssl-cert (1.1.3) ...
Selecting previously unselected package postgresql-common.
Preparing to unpack .../10-postgresql-common_278_all.deb ...
Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'
Unpacking postgresql-common (278) ...
Setting up libgdbm-compat4t64:amd64 (1.24-2) ...
Setting up ssl-cert (1.1.3) ...
Setting up perl-modules-5.40 (5.40.1-6) ...
Setting up libperl5.40:amd64 (5.40.1-6) ...
Setting up perl (5.40.1-6) ...
Setting up libjson-perl (4.10000-1) ...
Setting up postgresql-client-common (278) ...
Setting up libio-pty-perl (1:1.20-1+b3) ...
Setting up libipc-run-perl (20231003.0-2) ...
Setting up postgresql-common-dev (278) ...
Setting up postgresql-common (278) ...
Creating config file /etc/postgresql-common/createcluster.conf with new version
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'.
Processing triggers for man-db (2.13.1-1) ...
Processing triggers for libc-bin (2.41-12) ...
root@postgres-testserver:~# sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh
This script will enable the PostgreSQL APT repository on apt.postgresql.org on
your system. The distribution codename used will be trixie-pgdg.
Press Enter to continue, or Ctrl-C to abort.
Using keyring /usr/share/postgresql-common/pgdg/apt.postgresql.org.gpg
Writing /etc/apt/sources.list.d/pgdg.sources ...
Running apt-get update ...
Hit:1 <http://deb.debian.org/debian> trixie InRelease
Hit:2 <http://deb.debian.org/debian> trixie-updates InRelease
Hit:3 <http://mirror.hetzner.com/debian/packages> trixie InRelease
Get:4 <https://apt.postgresql.org/pub/repos/apt> trixie-pgdg InRelease [107 kB]
Hit:5 <http://mirror.hetzner.com/debian/packages> trixie-updates InRelease
Hit:6 <http://deb.debian.org/debian> trixie-backports InRelease
Hit:7 <http://deb.debian.org/debian-security> trixie-security InRelease
Hit:8 <http://mirror.hetzner.com/debian/packages> trixie-backports InRelease
Hit:9 <http://mirror.hetzner.com/debian/security> trixie-security InRelease
Get:10 <https://apt.postgresql.org/pub/repos/apt> trixie-pgdg/main amd64 Packages [351 kB]
Fetched 457 kB in 0s (966 kB/s)
Reading package lists... Done
You can now start installing packages from apt.postgresql.org.
Have a look at <https://wiki.postgresql.org/wiki/Apt> for more information;
most notably the FAQ at <https://wiki.postgresql.org/wiki/Apt/FAQ>
root@postgres-testserver:~# sudo apt install postgresql-14
Installing:
postgresql-14
Installing dependencies:
libllvm19 libpq5 libxslt1.1 libz3-4 postgresql-client-14
Suggested packages:
libpq-oauth postgresql-doc-14
Recommended packages:
sysstat
Summary:
Upgrading: 0, Installing: 6, Removing: 0, Not Upgrading: 41
Download size: 51.2 MB
Space needed: 216 MB / 36.9 GB available
Continue? [Y/n] y
Get:1 <http://deb.debian.org/debian> trixie/main amd64 libz3-4 amd64 4.13.3-1 [8,560 kB]
Get:2 <https://apt.postgresql.org/pub/repos/apt> trixie-pgdg/main amd64 libpq5 amd64 18.1-1.pgdg13+2 [248 kB]
Get:3 <http://deb.debian.org/debian> trixie/main amd64 libllvm19 amd64 1:19.1.7-3+b1 [26.0 MB]
Get:4 <https://apt.postgresql.org/pub/repos/apt> trixie-pgdg/main amd64 postgresql-client-14 amd64 14.20-1.pgdg13+1 [1,683 kB]
Get:5 <https://apt.postgresql.org/pub/repos/apt> trixie-pgdg/main amd64 postgresql-14 amd64 14.20-1.pgdg13+1 [14.5 MB]
Get:6 <http://deb.debian.org/debian> trixie/main amd64 libxslt1.1 amd64 1.1.35-1.2+deb13u2 [233 kB]
Fetched 51.2 MB in 1s (53.4 MB/s)
Preconfiguring packages ...
Selecting previously unselected package libz3-4:amd64.
(Reading database ... 36428 files and directories currently installed.)
Preparing to unpack .../0-libz3-4_4.13.3-1_amd64.deb ...
Unpacking libz3-4:amd64 (4.13.3-1) ...
Selecting previously unselected package libllvm19:amd64.
Preparing to unpack .../1-libllvm19_1%3a19.1.7-3+b1_amd64.deb ...
Unpacking libllvm19:amd64 (1:19.1.7-3+b1) ...
Selecting previously unselected package libpq5:amd64.
Preparing to unpack .../2-libpq5_18.1-1.pgdg13+2_amd64.deb ...
Unpacking libpq5:amd64 (18.1-1.pgdg13+2) ...
Selecting previously unselected package libxslt1.1:amd64.
Preparing to unpack .../3-libxslt1.1_1.1.35-1.2+deb13u2_amd64.deb ...
Unpacking libxslt1.1:amd64 (1.1.35-1.2+deb13u2) ...
Selecting previously unselected package postgresql-client-14.
Preparing to unpack .../4-postgresql-client-14_14.20-1.pgdg13+1_amd64.deb ...
Unpacking postgresql-client-14 (14.20-1.pgdg13+1) ...
Selecting previously unselected package postgresql-14.
Preparing to unpack .../5-postgresql-14_14.20-1.pgdg13+1_amd64.deb ...
Unpacking postgresql-14 (14.20-1.pgdg13+1) ...
Setting up libpq5:amd64 (18.1-1.pgdg13+2) ...
Setting up postgresql-client-14 (14.20-1.pgdg13+1) ...
update-alternatives: using /usr/share/postgresql/14/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up libz3-4:amd64 (4.13.3-1) ...
Setting up libxslt1.1:amd64 (1.1.35-1.2+deb13u2) ...
Setting up libllvm19:amd64 (1:19.1.7-3+b1) ...
Setting up postgresql-14 (14.20-1.pgdg13+1) ...
Creating new PostgreSQL cluster 14/main ...
/usr/lib/postgresql/14/bin/initdb -D /var/lib/postgresql/14/main --auth-local peer --auth-host scram-sha-256 --no-instructions
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /var/lib/postgresql/14/main ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
Processing triggers for postgresql-common (278) ...
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
Processing triggers for libc-bin (2.41-12) ...
root@postgres-testserver:~# sudo apt install postgresql-17
Installing:
postgresql-17
Installing dependencies:
postgresql-client-17
Suggested packages:
postgresql-doc-17
Recommended packages:
sysstat
Summary:
Upgrading: 0, Installing: 2, Removing: 0, Not Upgrading: 41
Download size: 18.6 MB
Space needed: 69.4 MB / 36.6 GB available
Continue? [Y/n]
Get:1 <https://apt.postgresql.org/pub/repos/apt> trixie-pgdg/main amd64 postgresql-client-17 amd64 17.7-3.pgdg13+1 [2,045 kB]
Get:2 <https://apt.postgresql.org/pub/repos/apt> trixie-pgdg/main amd64 postgresql-17 amd64 17.7-3.pgdg13+1 [16.6 MB]
Fetched 18.6 MB in 1s (33.7 MB/s)
Preconfiguring packages ...
Selecting previously unselected package postgresql-client-17.
(Reading database ... 38369 files and directories currently installed.)
Preparing to unpack .../postgresql-client-17_17.7-3.pgdg13+1_amd64.deb ...
Unpacking postgresql-client-17 (17.7-3.pgdg13+1) ...
Selecting previously unselected package postgresql-17.
Preparing to unpack .../postgresql-17_17.7-3.pgdg13+1_amd64.deb ...
Unpacking postgresql-17 (17.7-3.pgdg13+1) ...
Setting up postgresql-client-17 (17.7-3.pgdg13+1) ...
update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up postgresql-17 (17.7-3.pgdg13+1) ...
Processing triggers for postgresql-common (278) ...
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
root@postgres-testserver:~# ls -lah /etc/postgresql
total 12K
drwxr-xr-x 3 postgres postgres 4.0K Dec 14 15:32 .
drwxr-xr-x 78 root root 4.0K Dec 14 15:32 ..
drwxr-xr-x 3 postgres postgres 4.0K Dec 14 15:32 14
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Installing multiple Postgresql Versions in parallel, does not seem to work anymore
2025-12-14 15:58 Installing multiple Postgresql Versions in parallel, does not seem to work anymore Simon Hönscheid <[email protected]>
@ 2025-12-14 18:55 ` Christoph Berg <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Christoph Berg @ 2025-12-14 18:55 UTC (permalink / raw)
To: Simon Hönscheid <[email protected]>; +Cc: pgsql-pkg-debian
Re: Simon Hönscheid
> The Server is Running Debian 12 and the postgresql.org apt repository. Until
> today the Server was running Postgresql 14 and an upgrade to postgresql 17
> was planned. In the past I used to install the new version in parallel and
> migrated the data. Today I noticecd the post install steps did not run. No
> cluster was bootstrapped, no config directory created, no systemd unit
> created. There was also an upgrade planned to Debian 13, so I did this
> first, and tried again. Same result.
The packages are co-installable. What changed is that no new cluster
is created by default. If you want that, run `pg_createcluster 17 main`.
But the packaging is built about pg_upgradecluster, so you might just
run `pg_upgradecluster 14 main -v 17` instead.
Christoph
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-12-14 18:55 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-12-14 15:58 Installing multiple Postgresql Versions in parallel, does not seem to work anymore Simon Hönscheid <[email protected]>
2025-12-14 18:55 ` Christoph Berg <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox