Feedback-ID: i76984098:Fastmail
Message-ID: <6822d060-675e-4418-9d62-29c82f38c0c5@aklaver.com>
Date: Thu, 20 Jun 2024 08:03:45 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Postgresql python in upgraded version 16.2
To: =?UTF-8?Q?=C5=A0ika_Michal?= <michal.sika@spcss.cz>,
 "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
References: <AS8PR03MB8781D94903B5866E14BB81DD91C82@AS8PR03MB8781.eurprd03.prod.outlook.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <AS8PR03MB8781D94903B5866E14BB81DD91C82@AS8PR03MB8781.eurprd03.prod.outlook.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/6822d060-675e-4418-9d62-29c82f38c0c5%40aklaver.com>
Precedence: bulk

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@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 #
> 
> 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.klaver@aklaver.com