Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))

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.