BUG #17405: Minor upgrade from 12.9 to 12.10 works fine, but PSQL version shows "12.9"

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

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

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

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