Re: Problem with DEB packages

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
> > <stefanie@proopensource.eu> 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