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 trixie/main amd64 perl-modules-5.40 all 5.40.1-6 [3,019 kB] Get:2 trixie/main amd64 libgdbm-compat4t64 amd64 1.24-2 [50.3 kB] Get:3 trixie/main amd64 libperl5.40 amd64 5.40.1-6 [4,341 kB] Get:4 trixie/main amd64 perl amd64 5.40.1-6 [267 kB] Get:5 trixie/main amd64 libjson-perl all 4.10000-1 [87.5 kB] Get:6 trixie/main amd64 postgresql-client-common all 278 [47.1 kB] Get:7 trixie/main amd64 libio-pty-perl amd64 1:1.20-1+b3 [34.3 kB] Get:8 trixie/main amd64 libipc-run-perl all 20231003.0-2 [101 kB] Get:9 trixie/main amd64 postgresql-common-dev all 278 [72.4 kB] Get:10 trixie/main amd64 ssl-cert all 1.1.3 [16.8 kB] Get:11 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 trixie InRelease Hit:2 trixie-updates InRelease Hit:3 trixie InRelease Get:4 trixie-pgdg InRelease [107 kB] Hit:5 trixie-updates InRelease Hit:6 trixie-backports InRelease Hit:7 trixie-security InRelease Hit:8 trixie-backports InRelease Hit:9 trixie-security InRelease Get:10 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 for more information; most notably the FAQ at 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 trixie/main amd64 libz3-4 amd64 4.13.3-1 [8,560 kB] Get:2 trixie-pgdg/main amd64 libpq5 amd64 18.1-1.pgdg13+2 [248 kB] Get:3 trixie/main amd64 libllvm19 amd64 1:19.1.7-3+b1 [26.0 MB] Get:4 trixie-pgdg/main amd64 postgresql-client-14 amd64 14.20-1.pgdg13+1 [1,683 kB] Get:5 trixie-pgdg/main amd64 postgresql-14 amd64 14.20-1.pgdg13+1 [14.5 MB] Get:6 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 trixie-pgdg/main amd64 postgresql-client-17 amd64 17.7-3.pgdg13+1 [2,045 kB] Get:2 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