Sample Header Ad - 728x90

After upgrade Postgres python is the same version

0 votes
1 answer
104 views
I upgraded my postgres from 13.5 to 16.2 version (and the RHEL from 7.5 to 8.9). The problem is, python was not upgraded. I created procedure pyver():
CREATE OR REPLACE FUNCTION pyver ()
RETURNS TEXT
AS $$
    import sys
    pyversion = sys.version
    return pyversion
$$ LANGUAGE 'plpython3u';
For show of python version used by Postgres. When I run it on Python 13.5, I get this result:
# psql -d database
psql (13.5)
Type "help" for help.

postgres@database # select pyver();
                  pyver
-----------------------------------------
 3.6.8 (default, Aug 13 2020, 07:36:02) +
 [GCC 4.8.5 20150623 (Red Hat 4.8.5-39)]
(1 řádka)

postgres@database #
And when I run it on upgraded DB, I get this result:
# psql -d database
psql (16.2)
Type "help" for help.

database=# select pyver();
                  pyver
-----------------------------------------
 3.6.8 (default, Jan  5 2024, 09:14:44) +
 [GCC 8.5.0 20210514 (Red Hat 8.5.0-20)]
(1 row)

database=#
On the new RedHat is Python 3.9.18 installed. How do I get postgres to use a newer version of python? Upgrade was made by this way: - was installed new server with RedHat 8.9 (Python 3.9) - was installed Postgres binaries (version 13.5) and created user postgres - then was connected disk with Postgres databases (version 13.5) from old server - the DB's was started on new server - next step was installation of Postgres 16.2 - then was start with upgrade of DB's to new Postgres version via this command:
time /usr/pgsql-16/bin/pg_upgrade --jobs=16 -d /postgres/pgsql/database/data13 -D /postgres/pgsql/database/data16 -b /usr/pgsql-13/bin/ -B /usr/pgsql-16/bin/ --link
- after upgrade runs DB's on new version And now we find the proglem with Python. The main DB has 70TB size. Thanks Michal
Asked by Misudka (45 rep)
Jun 20, 2024, 05:50 AM
Last activity: Jun 21, 2024, 11:40 AM