public inbox for [email protected]help / color / mirror / Atom feed
Re: Postgresql python in upgraded version 16.2 3+ messages / 2 participants [nested] [flat]
* Re: Postgresql python in upgraded version 16.2 @ 2024-06-20 15:03 Adrian Klaver <[email protected]> 2024-06-21 07:33 ` Re: Postgresql python in upgraded version 16.2 =?iso-8859-2?Q?=A9ika_Michal?= <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Adrian Klaver @ 2024-06-20 15:03 UTC (permalink / raw) To: Šika Michal <[email protected]>; pgsql-general 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 [email protected] ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgresql python in upgraded version 16.2 2024-06-20 15:03 Re: Postgresql python in upgraded version 16.2 Adrian Klaver <[email protected]> @ 2024-06-21 07:33 ` =?iso-8859-2?Q?=A9ika_Michal?= <[email protected]> 2024-06-25 15:42 ` Re: Postgresql python in upgraded version 16.2 Adrian Klaver <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: =?iso-8859-2?Q?=A9ika_Michal?= @ 2024-06-21 07:33 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; 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 <[email protected]> Odesláno: čtvrtek 20. června 2024 17:03 Komu: Šika Michal <[email protected]>; [email protected] <[email protected]> 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@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 [email protected] ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgresql python in upgraded version 16.2 2024-06-20 15:03 Re: Postgresql python in upgraded version 16.2 Adrian Klaver <[email protected]> 2024-06-21 07:33 ` Re: Postgresql python in upgraded version 16.2 =?iso-8859-2?Q?=A9ika_Michal?= <[email protected]> @ 2024-06-25 15:42 ` Adrian Klaver <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Adrian Klaver @ 2024-06-25 15:42 UTC (permalink / raw) To: Šika Michal <[email protected]>; pgsql-general On 6/21/24 00:33, Šika Michal wrote: > Hello, > I get the install packages from this repository: > https://download.postgresql.org/pub/repos/yum/16/redhat/rhel-8.9-ppc64le/ <https://download.postgresql.org/pub/repos/yum/16/redhat/rhel-8.9-ppc64le/; I would go here: https://yum.postgresql.org/contact/ and use the Issue Tracker link. You will need to set up a Postgres community account to access the tracker. Clicking on the link will guide you through the process. > > Michal -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-06-25 15:42 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-06-20 15:03 Re: Postgresql python in upgraded version 16.2 Adrian Klaver <[email protected]> 2024-06-21 07:33 ` =?iso-8859-2?Q?=A9ika_Michal?= <[email protected]> 2024-06-25 15:42 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox