Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1)) - Mailing list pgsql-admin

From Roberto Carna
Subject Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))
Date
Msg-id CAG2Qp6uGCiP2hZh_VJqrBCshCJBkAiy+ZzH5eB9eY_riB1-KBA@mail.gmail.com
Whole thread Raw
In response to Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
Dear Ron, thank you so much for your help.

Please see the outputs:

$ pg_lsclusters
Ver Cluster Port Status Owner    Data directory              Log file
12  main    5432 online postgres /var/lib/postgresql/12/main
/var/log/postgresql/postgresql-12-main.log
13  main    5433 online postgres /var/lib/postgresql/13/main
/var/log/postgresql/postgresql-13-main.log

# echo $PATH
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

But if I wanna uninstall postgresql-13 and postgresql-client-13, maybe
the system will uninstall all the postgreslq packages (including
version 12)???

# apt remove --purge postgresql-13 postgresql-client-13
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be REMOVED:
  postgresql* postgresql-13* postgresql-client-13*

Thanks in advance again, regards!!!

El jue, 10 dic 2020 a las 13:22, Ron (<ronljohnsonjr@gmail.com>) escribió:
>
> 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.
>
>



pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))
Next
From: Creston Jamison
Date:
Subject: Re: Autovacuum Truncation Phase Loop?