Re: Problem with DEB packages

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
>>> <stefanie(at)proopensource(dot)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
>
Hi Michael,

There is only one local installation of PostgreSQL, that thing was
installed from scratch as mentioned in my first mail.

/Stefanie