pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9"
5+ messages / 4 participants
[nested] [flat]
* BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9"
@ 2022-02-15 11:07 PG Bug reporting form <noreply@postgresql.org>
2022-02-15 12:07 ` Re: BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9" hubert depesz lubaczewski <depesz@depesz.com>
2022-05-12 06:07 ` Re: BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9" Devrim Gündüz <devrim@gunduz.org>
0 siblings, 2 replies; 5+ messages in thread
From: PG Bug reporting form @ 2022-02-15 11:07 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: julian.garcia@inrop.es
The following bug has been logged on the website:
Bug reference: 17405
Logged by: Julian Garcia
Email address: julian.garcia@inrop.es
PostgreSQL version: 12.10
Operating system: Red Hat Enterprise Linux Server release 6.10 (Sant
Description:
Hi!
I've upgraded my Postgres version from 12.9 to 12.10 following the
documentation steps:
service postgresql-12 stop
yum update postgresql12-server
service postgresql-12 start
And the binaries do in fact show the upgraded version, the DB starts good,
everything went well:
postgres@dgojmysql01pre ~ $ rpm -qa | grep postgres
postgresql12-libs-12.10-1PGDG.rhel6.x86_64
postgresql12-server-12.10-1PGDG.rhel6.x86_64
postgresql12-12.10-1PGDG.rhel6.x86_64
But, when using the psql it would still show the 12.9 version:
root@myserver ~ # sudo su - postgres
postgres@myserver ~ $ psql
psql (12.9)
Type "help" for help.
postgres=#
Is it possible that this is a bug and even though the upgrade was flawless
it wouldn't reflect on the login message for psql? Thank you!!
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9"
2022-02-15 11:07 BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9" PG Bug reporting form <noreply@postgresql.org>
@ 2022-02-15 12:07 ` hubert depesz lubaczewski <depesz@depesz.com>
2022-02-15 15:05 ` Re: BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9" julian.garcia@inrop.es
1 sibling, 1 reply; 5+ messages in thread
From: hubert depesz lubaczewski @ 2022-02-15 12:07 UTC (permalink / raw)
To: julian.garcia@inrop.es; pgsql-bugs@lists.postgresql.org
On Tue, Feb 15, 2022 at 11:07:14AM +0000, PG Bug reporting form wrote:
> I've upgraded my Postgres version from 12.9 to 12.10 following the
> documentation steps:
>
> service postgresql-12 stop
> yum update postgresql12-server
> service postgresql-12 start
>
> And the binaries do in fact show the upgraded version, the DB starts good,
> everything went well:
>
> postgres@dgojmysql01pre ~ $ rpm -qa | grep postgres
> postgresql12-libs-12.10-1PGDG.rhel6.x86_64
> postgresql12-server-12.10-1PGDG.rhel6.x86_64
> postgresql12-12.10-1PGDG.rhel6.x86_64
>
> But, when using the psql it would still show the 12.9 version:
>
> root@myserver ~ # sudo su - postgres
> postgres@myserver ~ $ psql
> psql (12.9)
> Type "help" for help.
Please do:
sudo su - postgres
which psql
ls -l "$( which psql )" "$( readlink -f "$( which psql )" )"
rpm -qf "$( which psql )"
rpm -qf "$( readlink -f "$( which psql )" )"
and please share results of the which, ls, and rpm calls.
Best regards,
depesz
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9"
2022-02-15 11:07 BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9" PG Bug reporting form <noreply@postgresql.org>
2022-02-15 12:07 ` Re: BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9" hubert depesz lubaczewski <depesz@depesz.com>
@ 2022-02-15 15:05 ` julian.garcia@inrop.es
2022-02-15 15:15 ` Re: BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9" hubert depesz lubaczewski <depesz@depesz.com>
0 siblings, 1 reply; 5+ messages in thread
From: julian.garcia@inrop.es @ 2022-02-15 15:05 UTC (permalink / raw)
To: depesz@depesz.com; +Cc: pgsql-bugs@lists.postgresql.org
Hello,
Thank you for the quick reply. I share the output below:
root@myserver ~ # sudo su - postgres
postgres@myserver ~ $ which psql
/usr/bin/psql
postgres@myserver ~ $ ls -l "$( which psql )" "$( readlink -f "$( which
psql )" )"
lrwxrwxrwx 1 root root 28 Feb 15 11:25 /usr/bin/psql ->
/etc/alternatives/pgsql-psql
-rwxr-xr-x 1 root root 632176 Feb 9 15:21 /usr/pgsql-12/bin/psql
postgres@myserver ~ $ rpm -qf "$( which psql )"
file /usr/bin/psql is not owned by any package
postgres@myserver ~ $ rpm -qf "$( readlink -f "$( which psql )" )"
postgresql12-12.10-1PGDG.rhel6.x86_64
postgres@myserver ~ $
Best regards,
Julian
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9"
2022-02-15 11:07 BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9" PG Bug reporting form <noreply@postgresql.org>
2022-02-15 12:07 ` Re: BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9" hubert depesz lubaczewski <depesz@depesz.com>
2022-02-15 15:05 ` Re: BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9" julian.garcia@inrop.es
@ 2022-02-15 15:15 ` hubert depesz lubaczewski <depesz@depesz.com>
0 siblings, 0 replies; 5+ messages in thread
From: hubert depesz lubaczewski @ 2022-02-15 15:15 UTC (permalink / raw)
To: julian.garcia@inrop.es; +Cc: pgsql-bugs@lists.postgresql.org
On Tue, Feb 15, 2022 at 04:05:44PM +0100, julian.garcia@inrop.es wrote:
> root@myserver ~ # sudo su - postgres
> postgres@myserver ~ $ which psql
> /usr/bin/psql
> postgres@myserver ~ $ ls -l "$( which psql )" "$( readlink -f "$( which psql
> )" )"
> lrwxrwxrwx 1 root root 28 Feb 15 11:25 /usr/bin/psql ->
> /etc/alternatives/pgsql-psql
> -rwxr-xr-x 1 root root 632176 Feb 9 15:21 /usr/pgsql-12/bin/psql
> postgres@myserver ~ $ rpm -qf "$( which psql )"
> file /usr/bin/psql is not owned by any package
> postgres@myserver ~ $ rpm -qf "$( readlink -f "$( which psql )" )"
> postgresql12-12.10-1PGDG.rhel6.x86_64
This does look wrong, and if someone on clean install can confirm it
would be good to track down and fix.
I'd guess it's some issue with packaging, but how it happened - no idea,
sorry.
Best regards,
depesz
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9"
2022-02-15 11:07 BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9" PG Bug reporting form <noreply@postgresql.org>
@ 2022-05-12 06:07 ` Devrim Gündüz <devrim@gunduz.org>
1 sibling, 0 replies; 5+ messages in thread
From: Devrim Gündüz @ 2022-05-12 06:07 UTC (permalink / raw)
To: julian.garcia@inrop.es; pgsql-bugs@lists.postgresql.org
Hi,
Sorry for the late reply. This was definitely my mistake, and found the
reason accidentally while working on today's minor release updates.
12.11 will include a fix for that. Sorry for the inconvenience.
Regards, Devrim
On Tue, 2022-02-15 at 11:07 +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 17405
> Logged by: Julian Garcia
> Email address: julian.garcia@inrop.es
> PostgreSQL version: 12.10
> Operating system: Red Hat Enterprise Linux Server release 6.10
> (Sant
> Description:
>
> Hi!
>
> I've upgraded my Postgres version from 12.9 to 12.10 following the
> documentation steps:
>
> service postgresql-12 stop
> yum update postgresql12-server
> service postgresql-12 start
>
> And the binaries do in fact show the upgraded version, the DB starts
> good,
> everything went well:
>
> postgres@dgojmysql01pre ~ $ rpm -qa | grep postgres
> postgresql12-libs-12.10-1PGDG.rhel6.x86_64
> postgresql12-server-12.10-1PGDG.rhel6.x86_64
> postgresql12-12.10-1PGDG.rhel6.x86_64
>
> But, when using the psql it would still show the 12.9 version:
>
> root@myserver ~ # sudo su - postgres
> postgres@myserver ~ $ psql
> psql (12.9)
> Type "help" for help.
>
> postgres=#
>
> Is it possible that this is a bug and even though the upgrade was
> flawless
> it wouldn't reflect on the login message for psql? Thank you!!
>
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachments:
signature.asc (application/pgp-signature, 832B) download
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2022-05-12 06:07 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-02-15 11:07 BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9" PG Bug reporting form <noreply@postgresql.org>
2022-02-15 12:07 ` hubert depesz lubaczewski <depesz@depesz.com>
2022-02-15 15:05 ` julian.garcia@inrop.es
2022-02-15 15:15 ` hubert depesz lubaczewski <depesz@depesz.com>
2022-05-12 06:07 ` Devrim Gündüz <devrim@gunduz.org>
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