Subject: Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian
 12.5-1.pgdg100+1))
To: pgsql-admin@lists.postgresql.org
References: 
 <CAG2Qp6sQt-DU+RsN1PUA3gJfbMYfAryzmK4xz=BY_rHChYs=uQ@mail.gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
Message-ID: <85a89a29-47e9-e11f-32b9-f8205d7a570f@gmail.com>
Date: Thu, 10 Dec 2020 10:22:00 -0600
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.10.0
MIME-Version: 1.0
In-Reply-To: 
 <CAG2Qp6sQt-DU+RsN1PUA3gJfbMYfAryzmK4xz=BY_rHChYs=uQ@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Precedence: bulk

On 12/10/20 9:43 AM, Roberto Carna wrote:
> Dear, I'm new at postgresql and I've installed it on a Debian 10
> (stable) server.
>
> I don't know why, but after executing the psql command, I see this message:
>
> psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))
>
> It seems both the posqgresql 12 and 13 are installed at the same time...
>
> I think I've installed postgresql 12, but here I see I have these
> packages after upgrade with apt:
>
> ii  postgresql                      13+223.pgdg100+1             all
>         object-relational SQL database (supported version)
> ii  postgresql-12                   12.5-1.pgdg100+1             amd64
>         object-relational SQL database, version 12 server
> ii  postgresql-13                   13.1-1.pgdg100+1             amd64
>         object-relational SQL database, version 13 server
> ii  postgresql-client-12            12.5-1.pgdg100+1             amd64
>         front-end programs for PostgreSQL 12
> ii  postgresql-client-13            13.1-1.pgdg100+1             amd64
>         front-end programs for PostgreSQL 13
> ii  postgresql-client-common        223.pgdg100+1                all
>         manager for multiple PostgreSQL client versions
> ii  postgresql-common               223.pgdg100+1                all
>         PostgreSQL database-cluster manager
>
> Is this correct or do I have to uninstall the postgresql 13 packages ?

"Correct" is in the eye of the beholder.  Leave both installed, or deinstall 
the one you don't want.

> Within psql CLI, the version is:
>
> SELECT version();
>
>   PostgreSQL 12.5 (Debian 12.5-1.pgdg100+1) on x86_64-pc-linux-gnu,
> compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
> (1 row)

Run the pg_lsclusters to see what database instances (Postgres confusingly 
calls them "clusters") are configured.

Also, echo $PATH to see what binaries that Debian will see first.

-- 
Angular momentum makes the world go 'round.