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.