From: | Šika Michal <michal(dot)sika(at)spcss(dot)cz> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgresql python in upgraded version 16.2 |
Date: | 2024-06-21 07:33:01 |
Message-ID: | AS8PR03MB87810A38193039CC55F59FBC91C92@AS8PR03MB8781.eurprd03.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I get the install packages from this repository:
https://download.postgresql.org/pub/repos/yum/16/redhat/rhel-8.9-ppc64le/
Michal
________________________________
Od: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Odesláno: čtvrtek 20. června 2024 17:03
Komu: Šika Michal <michal(dot)sika(at)spcss(dot)cz>; pgsql-general(at)postgresql(dot)org <pgsql-general(at)postgresql(dot)org>
Předmět: Re: Postgresql python in upgraded version 16.2
On 6/19/24 22:05, Šika Michal wrote:
> TLP:AMBER
>
>
> Hello all,
> I upgraded version of Postgres from 13.5 to newest 16.2. But Python was
> not upgraded.
>
> I create procedure pyver():
> CREATE OR REPLACE FUNCTION pyver ()
> RETURNS TEXT
> AS $$
> import sys
> pyversion = sys.version
> return pyversion
> $$ LANGUAGE 'plpython3u';
>
> On the Postgres 13.5 I get this result:
> # psql -d database
> psql (13.5)
> Type "help" for help.
>
> postgres(at)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(at)database #
>
> On the Postgres 16.2 (upgraded from version 13.5) 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=#
>
> It seems python was not upgraded when I upgrade PostgreSQL. Is possible
> upgrade the python to actual version 3.9.x installed on RedHat 8.5 ?
Where are you getting the packages from, the Red Hat repo or the PGDG repo?
>
> Thanks
> Michal
>
> TLP:AMBER
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Maxwell Dreytser | 2024-06-21 14:41:55 | RowDescription for a function does not include table OID |
Previous Message | Achilleas Mantzios | 2024-06-20 17:09:35 | Re: Autovacuum, dead tuples and bloat |