Обсуждение: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))
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 ? 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) Thanks a lot!!!
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.
Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))
От
Roberto Carna
Дата:
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. > >
On 12/10/20 10:40 AM, Stéphane KANSCHINE wrote: [snip] > Why do you want to remove 13 and not version 12 ? His application might not be tested and certified on v13. (Being a contract DBA, I face this issue on a regular basis: company buys 3rd party software from a small company which only tests on a small set of versions. Or the company might not want to run their mission critical software on .1 software. Or the company is too cheap to upgrade working software even though it's EOL.) -- Angular momentum makes the world go 'round.
Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))
От
Roberto Carna
Дата:
Thanks You very much!!!
I've uninstalled postgresql 13 and now I have just versión 12 running.
Regards.
El jue., 10 de diciembre de 2020 14:10, Ron <ronljohnsonjr@gmail.com> escribió:
On 12/10/20 10:40 AM, Stéphane KANSCHINE wrote:
[snip]
> Why do you want to remove 13 and not version 12 ?
His application might not be tested and certified on v13. (Being a contract
DBA, I face this issue on a regular basis: company buys 3rd party software
from a small company which only tests on a small set of versions. Or the
company might not want to run their mission critical software on .1
software. Or the company is too cheap to upgrade working software even
though it's EOL.)
--
Angular momentum makes the world go 'round.