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

From: Roberto Carna <robertocarna36(at)gmail(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))
Date: 2020-12-10 16:31:10
Message-ID: CAG2Qp6uGCiP2hZh_VJqrBCshCJBkAiy+ZzH5eB9eY_riB1-KBA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)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.
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stéphane KANSCHINE 2020-12-10 16:40:09 Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))
Previous Message Ron 2020-12-10 16:22:00 Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))