From: =?iso-8859-2?Q?=A9ika_Michal?= <michal.sika@spcss.cz>
To: Adrian Klaver <adrian.klaver@aklaver.com>, "pgsql-general@postgresql.org"
	<pgsql-general@postgresql.org>
Subject: Re: Postgresql python in upgraded version 16.2
Thread-Topic: Postgresql python in upgraded version 16.2
Thread-Index: AQHaws4jzNjpxT61rES9fUU0L7+Su7HQwHuAgAEUKTM=
Date: Fri, 21 Jun 2024 07:33:01 +0000
Message-ID:
 <AS8PR03MB87810A38193039CC55F59FBC91C92@AS8PR03MB8781.eurprd03.prod.outlook.com>
References:
 <AS8PR03MB8781D94903B5866E14BB81DD91C82@AS8PR03MB8781.eurprd03.prod.outlook.com>
 <6822d060-675e-4418-9d62-29c82f38c0c5@aklaver.com>
In-Reply-To: <6822d060-675e-4418-9d62-29c82f38c0c5@aklaver.com>
Accept-Language: cs-CZ, en-US
Content-Language: cs-CZ
msip_labels:
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=spcss.cz;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: AS8PR03MB8781:EE_|VI2PR03MB10740:EE_
x-ms-office365-filtering-correlation-id: c596b683-e2af-4650-f0a2-08dc91c46173
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;ARA:13230037|366013|376011|1800799021|38070700015;
x-microsoft-antispam-message-info:
 =?iso-8859-2?Q?LdsTH3G7TIFMl0ouWqUsfsqDt2F2nNpS0slc4wij/+ZhqfN38gwiEQfFqz?=
 =?iso-8859-2?Q?LetsznDmABW8jGfXS9S9nlsaa3yGimJFzPnNIz1ycq7oqmNGO3pAWbsV7Y?=
 =?iso-8859-2?Q?xQ4LMCAh8E5pOU81GnWZAit2csaZIbssPW4On/QSRbj5Wfp2PVxxMUvOKE?=
 =?iso-8859-2?Q?wW9YW0WtdLxz3Bbu6oXdkl1l4JoWJV5aR/iHAaw2MhUjlf2RZah4Xmzox5?=
 =?iso-8859-2?Q?BQGKxn7V0513vda2rtVQKi1sjtjQX47Scyp4tRlUMsq9vNii2fqs2m8smO?=
 =?iso-8859-2?Q?DPeCFuyZ0flg5lDYG0+a3v8kgRidOKJzHz7zQoH34GDdQcqW/a3ac6bzRQ?=
 =?iso-8859-2?Q?lTNh6frI9ot/AJuhVObkpM/syhx5o5XHfDIcdDAez+0Ys/aAjnI2R1O+ap?=
 =?iso-8859-2?Q?BigqJgBcqwHeaUvhip7ckqO2SEXS4Vy1AXGjKS1lwZP0V4xrQ+uM+2OVNX?=
 =?iso-8859-2?Q?E7Ijp0r53eMe6m8kAu4CvdJw6ecS2/jT460ECurH1Ea4bADEdvV+rg9JBN?=
 =?iso-8859-2?Q?K4chYmQzbhIff6w0M+oSEJ/sC8lEUBt/DKY28qPK5miaCDfOcAt9+Xx7be?=
 =?iso-8859-2?Q?H8/Qzasr2NeY0SQurXuJmjTeFHGpEFMI3OGlBoUQ7F2h3eJpkaZm8NDO24?=
 =?iso-8859-2?Q?tTkb9R8M+1fr88TgUXMItQS5VbZPenZ/C6bFPNBnIsc4TcQg/lU/sXoXca?=
 =?iso-8859-2?Q?y2Mh7HBxJ+y6eDPQGWjEoYuUE4gWkFltSyXXjuBoKlHIdHqO6Uzx4iorOd?=
 =?iso-8859-2?Q?IZjOSsMC5hhSNUWUGfoqHFbeH+8H5G5+UlLgI4fLm1Pza/oI1Hdjf0Da1/?=
 =?iso-8859-2?Q?8XTwac4bYyC4r/ZfbZnHA/wNAIyX6oDjvxL9jX9rx4uJfINsh0NVmiOPHg?=
 =?iso-8859-2?Q?p046BImTFi5r8UZBv69nxgAsxK8KLVu+msX3kJIFssHQqVLuD2nCbRtZYE?=
 =?iso-8859-2?Q?UoitHbVYPxFr5twWgmjRLJxIs3vnYw5dV7s9vzM4iECwYTjMkhH5c/s57d?=
 =?iso-8859-2?Q?12veBsm2TloJEfUu9JQQzohoql/0aCoMnu6uRMAJt+yJiqnQ5zhVb2kYH9?=
 =?iso-8859-2?Q?PRGDcsUX8WHDU48ybSIh46ZH/ZbdhUN9IQdHcQE91QlfDIIQtVSBasjOCg?=
 =?iso-8859-2?Q?BUp5D2soIjPzawTJKfYvOetDRZxu3F0TMUtGgFTdTy468KwVeIVA4BzRw/?=
 =?iso-8859-2?Q?RtzNGJASRumjdCYPOVdPXPRoNSAnvXaLlJDJTybGFu1HOYZElNsJ425lg6?=
 =?iso-8859-2?Q?kQeVkd1Fugt06aSPaoiCDsDvn/fpfeI5ucYvoBiU7oDWBX8p9+DiftDnn/?=
 =?iso-8859-2?Q?yIlsUyopHlRnZww/s7YtYLg2zEBIcW+58rQGg1WWeDciHFEF3DECuZf/Cb?=
 =?iso-8859-2?Q?Fye8+fhcO5?=
x-forefront-antispam-report:
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AS8PR03MB8781.eurprd03.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230037)(366013)(376011)(1800799021)(38070700015);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?iso-8859-2?Q?zpDjAgRsAHmvy9wtXgbLadmeRektDXbtpDH/izM0zUj8hWdwyH57vvfiSA?=
 =?iso-8859-2?Q?Rs+zuPm+CNC6NyaaLHitgTC1gr/VT974EYDMfUAx3rvayKPl00aTz/7gPH?=
 =?iso-8859-2?Q?OaRNDSeZXWbX8qLpkwpgB/53WY9sa3sLQAN+GBTxsWtuYdTrS7fLMZeHOb?=
 =?iso-8859-2?Q?NMQBhfEYhG5dI4JFq2NMZ8wkjgDXk/bnBxLMTDkRA9gaHP3I036y0LsSo9?=
 =?iso-8859-2?Q?2WYynnb5nyF1vi+0CjaJQD2ntGetJLulSX+tCtZrxeI9pTNVMi9r/T65Ir?=
 =?iso-8859-2?Q?9sUIx5qReSNX4ZKwdY2ebLmVyzEYM/Ov1aqmXhm9gqv+pb4VVzUpEs4wW8?=
 =?iso-8859-2?Q?pW71Lu6gQFZlp6fFgPOj6aPKkodFuHAyrj+Miud2YP8GnV+N9mVQRB8ipp?=
 =?iso-8859-2?Q?JS7mARDmn7JfJUaWdy0A0AqHm9ZeAdoZFOszoyEcE/+sZnLfmYFNMjteas?=
 =?iso-8859-2?Q?5ifX4Lipmk5j1AnyDfCZjQQfwYuhXYcAEL+eZ5R6YBiQ+WbPGHZX5y5AJh?=
 =?iso-8859-2?Q?2MFwkpP0o1YKiPu2KKCABZ4PdQ+7vZ28hZWumKR/PqzpdCyavV59TLSxfg?=
 =?iso-8859-2?Q?dwIx20lgayDt8xFt+SMNYyLv8rfoCrq6UzRqQASUWMRgG9aVox+tEREDFr?=
 =?iso-8859-2?Q?dPctMnTByTEnPWuS6cnzqGRSK+dPYYD8ohRIrNGGmAu3yOKpP38P4NO6O7?=
 =?iso-8859-2?Q?7NsMHbXrBe+ArvLnM0SizCqhMNJXrwDxChSBzbRxrIWmZXHw1ScLo+gr7D?=
 =?iso-8859-2?Q?hc6XRx7Ihig2Q4nSWL4SEsXETknsPGnetRQh4lScPD03bTmXwv+cTkwcjd?=
 =?iso-8859-2?Q?cRUSKhug2+Irbh4Gwvvh76GsQsuc+15csDMVjEhGP6Raq3XRJOmEasC7NB?=
 =?iso-8859-2?Q?Z5da425CNMQfGkKfXNDslRJrAy37iiYLDkcIwjchE0U7Om/+jwcMJU14Ed?=
 =?iso-8859-2?Q?ngwcb+v2U/ifIHRuutblLcf5E6ebnhkafSv328q+7/qsnQXwJEF1zimsYk?=
 =?iso-8859-2?Q?E5Kt3zBRhggGVC6ASO97pcM7KPS8No4DfzZ2Y3B/y6hN4eHiChm4r5f/67?=
 =?iso-8859-2?Q?pVh0cTUyKH2BFEywWhaTLDqc2oHlxQEkA9zVfL8H56I53/YOOJa661QhTP?=
 =?iso-8859-2?Q?fbJAUevG7Kcd4m7F7dQv/65sB/JnHCxeWg+SGBLM7swI+I0U91FNhlHQeO?=
 =?iso-8859-2?Q?vJ+c9c1F8bi/fxGoVV8owetYHbWsPOZQGJtNVSk0VLxe0VSkN64RZKdnmL?=
 =?iso-8859-2?Q?M9NqgO0g/oZE/FJZesp0lTpoxX+2EmWshyRxD5bbG7lHVYJ+mkzL4mEB+r?=
 =?iso-8859-2?Q?ByuGcIhnXK2Lbn370jDILv8zXHF3Xb/Nc3IGcRIStwigkcQ6wAvS2ZBYPC?=
 =?iso-8859-2?Q?jCUviCZaPKDJKlGfGLK+vM0wZDSKLy+2s1aJR7u2UiVPQhyK7Ft6i5QdBn?=
 =?iso-8859-2?Q?qK2CPbzlMfzQcqH9t1zgllvJiLtnGSAgiEcpi5f+79/hHjFtIQD3zwtXJL?=
 =?iso-8859-2?Q?2GIEoS3p+r/HLqBy0FVhp8UnlVIxBJOT35bT8M28IfPOdawiUDaH2oU92y?=
 =?iso-8859-2?Q?PsJXRJFyvwAUdf3QUxyip2OLBVQABPks+G0PCccO1nYs3lnP/9V8cOro/p?=
 =?iso-8859-2?Q?sic5W0BUqHwX4OrwH3KABkbn6/3bEuQjfo?=
Content-Type: multipart/alternative;
	boundary="_000_AS8PR03MB87810A38193039CC55F59FBC91C92AS8PR03MB8781eurp_"
MIME-Version: 1.0
X-OriginatorOrg: spcss.cz
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: AS8PR03MB8781.eurprd03.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: c596b683-e2af-4650-f0a2-08dc91c46173
X-MS-Exchange-CrossTenant-originalarrivaltime: 21 Jun 2024 07:33:01.4164
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 8ef2ef64-61e6-4033-9f7f-48ccd5d03c90
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: TWuAOjk5TvB2WXgWyVx3SRCM8SAGqbfhGhnRzBsqqN+Nz6WNOVvvo/OqX9qs3fK/AyKFwuLAoKSiWfPSV12mgg==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: VI2PR03MB10740
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/AS8PR03MB87810A38193039CC55F59FBC91C92%40AS8PR03MB8781.eurprd03.prod.outlook.com>
Precedence: bulk

--_000_AS8PR03MB87810A38193039CC55F59FBC91C92AS8PR03MB8781eurp_
Content-Type: text/plain; charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

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.klaver@aklaver.com>
Odesl=E1no: =E8tvrtek 20. =E8ervna 2024 17:03
Komu: =A9ika Michal <michal.sika@spcss.cz>; pgsql-general@postgresql.org <p=
gsql-general@postgresql.org>
P=F8edm=ECt: Re: Postgresql python in upgraded version 16.2

On 6/19/24 22:05, =A9ika 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 =3D 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 =F8=E1dka)
>
> 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=3D# 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=3D#
>
> 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


--_000_AS8PR03MB87810A38193039CC55F59FBC91C92AS8PR03MB8781eurp_
Content-Type: text/html; charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
2">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
Hello,</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
I get the install packages from this repository:</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
<a href=3D"https://download.postgresql.org/pub/repos/yum/16/redhat/rhel-8.9=
-ppc64le/" id=3D"LPlnk848503">https://download.postgresql.org/pub/repos/yum=
/16/redhat/rhel-8.9-ppc64le/</a></div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
Michal</div>
<div id=3D"appendonsend"></div>
<hr style=3D"display:inline-block;width:98%" tabindex=3D"-1">
<div id=3D"divRplyFwdMsg" dir=3D"ltr"><font face=3D"Calibri, sans-serif" st=
yle=3D"font-size:11pt" color=3D"#000000"><b>Od:</b> Adrian Klaver &lt;adria=
n.klaver@aklaver.com&gt;<br>
<b>Odesl=E1no:</b> =E8tvrtek 20. =E8ervna 2024 17:03<br>
<b>Komu:</b> =A9ika Michal &lt;michal.sika@spcss.cz&gt;; pgsql-general@post=
gresql.org &lt;pgsql-general@postgresql.org&gt;<br>
<b>P=F8edm=ECt:</b> Re: Postgresql python in upgraded version 16.2</font>
<div>&nbsp;</div>
</div>
<div class=3D"BodyFragment"><font size=3D"2"><span style=3D"font-size:11pt;=
">
<div class=3D"PlainText">On 6/19/24 22:05, =A9ika Michal wrote:<br>
&gt; TLP:AMBER<br>
&gt; <br>
&gt; <br>
&gt; Hello all,<br>
&gt; I upgraded version of Postgres from 13.5 to newest 16.2. But Python wa=
s <br>
&gt; not upgraded.<br>
&gt; <br>
&gt; I create procedure pyver():<br>
&gt; CREATE OR REPLACE FUNCTION pyver ()<br>
&gt;&nbsp; &nbsp;RETURNS TEXT<br>
&gt;&nbsp; &nbsp;AS $$<br>
&gt;&nbsp; &nbsp; &nbsp; &nbsp;import sys<br>
&gt;&nbsp; &nbsp; &nbsp; &nbsp;pyversion =3D sys.version<br>
&gt;&nbsp; &nbsp; &nbsp; &nbsp;return pyversion<br>
&gt;&nbsp; &nbsp;$$ LANGUAGE 'plpython3u';<br>
&gt; <br>
&gt; On the Postgres 13.5 I get this result:<br>
&gt; # psql -d database<br>
&gt; psql (13.5)<br>
&gt; Type &quot;help&quot; for help.<br>
&gt; <br>
&gt; postgres@database # select pyver();<br>
&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; p=
yver<br>
&gt; -----------------------------------------<br>
&gt;&nbsp; &nbsp;3.6.8 (default, Aug 13 2020, 07:36:02) +<br>
&gt;&nbsp; &nbsp;[GCC 4.8.5 20150623 (Red Hat 4.8.5-39)]<br>
&gt; (1 =F8=E1dka)<br>
&gt; <br>
&gt; postgres@database #<br>
&gt; <br>
&gt; On the Postgres 16.2 (upgraded from version 13.5) I get this result:<b=
r>
&gt; # psql -d database<br>
&gt; psql (16.2)<br>
&gt; Type &quot;help&quot; for help.<br>
&gt; <br>
&gt; database=3D# select pyver();<br>
&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; p=
yver<br>
&gt; -----------------------------------------<br>
&gt;&nbsp; &nbsp;3.6.8 (default, Jan &nbsp;5 2024, 09:14:44) +<br>
&gt;&nbsp; &nbsp;[GCC 8.5.0 20210514 (Red Hat 8.5.0-20)]<br>
&gt; (1 row)<br>
&gt; <br>
&gt; database=3D#<br>
&gt; <br>
&gt; It seems python was not upgraded when I upgrade PostgreSQL. Is possibl=
e <br>
&gt; upgrade the python to actual version 3.9.x installed on RedHat 8.5 ?<b=
r>
<br>
Where are you getting the packages from, the Red Hat repo or the PGDG repo?=
<br>
<br>
&gt; <br>
&gt; Thanks<br>
&gt; Michal<br>
&gt; <br>
&gt; TLP:AMBER<br>
&gt; <br>
<br>
-- <br>
Adrian Klaver<br>
adrian.klaver@aklaver.com<br>
<br>
</div>
</span></font></div>
</body>
</html>

--_000_AS8PR03MB87810A38193039CC55F59FBC91C92AS8PR03MB8781eurp_--