pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpsql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))
6+ messages / 3 participants
[nested] [flat]
* psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))
@ 2020-12-10 15:43 Roberto Carna <robertocarna36@gmail.com>
2020-12-10 16:22 ` Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1)) Ron <ronljohnsonjr@gmail.com>
2020-12-10 16:40 ` Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1)) Stéphane KANSCHINE <stephane@hexack.fr>
0 siblings, 2 replies; 6+ messages in thread
From: Roberto Carna @ 2020-12-10 15:43 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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!!!
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))
2020-12-10 15:43 psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1)) Roberto Carna <robertocarna36@gmail.com>
@ 2020-12-10 16:22 ` Ron <ronljohnsonjr@gmail.com>
2020-12-10 16:31 ` Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1)) Roberto Carna <robertocarna36@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Ron @ 2020-12-10 16:22 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))
2020-12-10 15:43 psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1)) Roberto Carna <robertocarna36@gmail.com>
2020-12-10 16:22 ` Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1)) Ron <ronljohnsonjr@gmail.com>
@ 2020-12-10 16:31 ` Roberto Carna <robertocarna36@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Roberto Carna @ 2020-12-10 16:31 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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.
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))
2020-12-10 15:43 psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1)) Roberto Carna <robertocarna36@gmail.com>
@ 2020-12-10 16:40 ` Stéphane KANSCHINE <stephane@hexack.fr>
2020-12-10 17:09 ` Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1)) Ron <ronljohnsonjr@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Stéphane KANSCHINE @ 2020-12-10 16:40 UTC (permalink / raw)
To: Roberto Carna <robertocarna36@gmail.com>; pgsql-admin@lists.postgresql.org
Le jeu. 10 déc., vers 12:43, Roberto Carna exprimait :
> 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 means that you use the PostgreSQL client 13 version, which is connected on
the PostgreSQL server version 12. Because PostgreSQL 12 was installed
before and took the default PostgreSQL port, 5432. If PostgreSQL 13 has
been installed after, it listens on port 5433.
In order to confirmn, you can try to launch: psql -p 5433
> It seems both the posqgresql 12 and 13 are installed at the same time...
It's useful to make migrations.
> Is this correct or do I have to uninstall the postgresql 13 packages ?
Why do you want to remove 13 and not version 12 ?
Regards,
--
Stéphane KANSCHINE - https://www.hexack.fr./ - https://www.nuajik.io./
＠ stephane@hexack.fr
+33 6 64 31 72 52
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))
2020-12-10 15:43 psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1)) Roberto Carna <robertocarna36@gmail.com>
2020-12-10 16:40 ` Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1)) Stéphane KANSCHINE <stephane@hexack.fr>
@ 2020-12-10 17:09 ` Ron <ronljohnsonjr@gmail.com>
2020-12-10 19:13 ` Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1)) Roberto Carna <robertocarna36@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Ron @ 2020-12-10 17:09 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1))
2020-12-10 15:43 psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1)) Roberto Carna <robertocarna36@gmail.com>
2020-12-10 16:40 ` Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1)) Stéphane KANSCHINE <stephane@hexack.fr>
2020-12-10 17:09 ` Re: psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1)) Ron <ronljohnsonjr@gmail.com>
@ 2020-12-10 19:13 ` Roberto Carna <robertocarna36@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Roberto Carna @ 2020-12-10 19:13 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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.
>
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2020-12-10 19:13 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-12-10 15:43 psql (13.1 (Debian 13.1-1.pgdg100+1), server 12.5 (Debian 12.5-1.pgdg100+1)) Roberto Carna <robertocarna36@gmail.com>
2020-12-10 16:22 ` Ron <ronljohnsonjr@gmail.com>
2020-12-10 16:31 ` Roberto Carna <robertocarna36@gmail.com>
2020-12-10 16:40 ` Stéphane KANSCHINE <stephane@hexack.fr>
2020-12-10 17:09 ` Ron <ronljohnsonjr@gmail.com>
2020-12-10 19:13 ` Roberto Carna <robertocarna36@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox