Am 30.09.25 um 11:36 schrieb Michael Banck:
Hi,
On Tue, Sep 30, 2025 at 11:17:07AM +0200, Stefanie Janine Stölting wrote:
Am 30.09.25 um 10:50 schrieb Thom Brown:
On Tue, 30 Sept 2025 at 09:12, Stefanie Janine Stölting
<[email protected]> wrote:
Hi there,
I installed a fresh Debian 13 and added the packages
fromhttps://www.postgresql.org/download/linux/debian/.
Afterwards I wanted to install PostgreSQL 17, but I ended up with PostgreSQL 18.
I named 17, the installation messages said it is 17.
It seems you ended up with both; it is a bit unclear why PostgreSQL 18
got installed as Debian 13 has 17 by default. Maybe an apt upgrade
pulled in a new postgresql meta-package that depends on postgresql-18.
sudo su postgres
psql
If you have multiple versions of the client package installed, you need
to specify the version explicitly, like Thom showed.
psql (18.0 (Debian 18.0-1.pgdg13+3))
Geben Sie »help« für Hilfe ein.
postgres=# select version();
version
--------------------------------------------------------------------------------------------------------------------
PostgreSQL 18.0 (Debian 18.0-1.pgdg13+3) on x86_64-pc-linux-gnu, compiled by
gcc (Debian 14.2.0-19) 14.2.0, 64-bit
If you want to connect to a particular instance, you need to pass the
port or the PGCLUSTER environment variable or the pg_wrapper --cluster
option, like "psql --cluster 17/main". pg_lsclusters will show you which
instances are around and which ports they have. It seems you have at
least a 18/main and a 17/main cluster.
Michael
Hi Michael,
There is only one local installation of PostgreSQL, that thing was
installed from scratch as mentioned in my first mail.
/Stefanie
