Thread: Python3 for PostgreSQL 14

Python3 for PostgreSQL 14

From
Дмитрий Иванов
Date:
Good afternoon. Tell me what version of Python3 PostgreSQL 14 is targeting. I had problems with pairing version 12, working on 3.7.4

Re: Python3 for PostgreSQL 14

From
Adrian Klaver
Date:
On 10/22/21 19:58, Дмитрий Иванов wrote:
> Good afternoon. Tell me what version of Python3 PostgreSQL 14 is 
> targeting. I had problems with pairing version 12, working on 3.7.4

1) Where did you install Postgres from?

2) Define problems.

3) To be clear you are trying to use plpython3u, correct?


-- 
Adrian Klaver
adrian.klaver@aklaver.com



Re: Python3 for PostgreSQL 14

From
Дмитрий Иванов
Date:
Да. 
Python extension issues occurred on Windows Server 2012 and Windows 10 Pro. Experimentally, when installing version 3.7.4, everything worked. This is my first time deploying Debian, and since I didn't want to deploy multiple versions, I asked a question. I have installed Python 3.10 x64. when faced with a lack of information on installing an extension pack, it would be a good idea to highlight this in the help. https://debian.pkgs.org/11/postgresql-amd64/postgresql-plpython3-14_14.0-1.pgdg110+1_amd64.deb.html:
# sudo apt-get install postgresql-plpython3-14
After that, I have successfully installed the extension and executed the audit function

сб, 23 окт. 2021 г. в 09:04, Adrian Klaver <adrian.klaver@aklaver.com>:
On 10/22/21 19:58, Дмитрий Иванов wrote:
> Good afternoon. Tell me what version of Python3 PostgreSQL 14 is
> targeting. I had problems with pairing version 12, working on 3.7.4

1) Where did you install Postgres from?

2) Define problems.

3) To be clear you are trying to use plpython3u, correct?


--
Adrian Klaver
adrian.klaver@aklaver.com

Re: Python3 for PostgreSQL 14

From
Adrian Klaver
Date:
On 10/23/21 13:00, Дмитрий Иванов wrote:
> Да.
> Python extension issues occurred on Windows Server 2012 and Windows 10 
> Pro. Experimentally, when installing version 3.7.4, everything worked. 

If you used the EDB installer for the Windows install of Postgres then 
you need to use their Language Pack to match up with what the plpython 
expects.

> This is my first time deploying Debian, and since I didn't want to 
> deploy multiple versions, I asked a question. I have installed Python 
> 3.10 x64. when faced with a lack of information on installing an 
> extension pack, it would be a good idea to highlight this in the help. 
> https://debian.pkgs.org/11/postgresql-amd64/postgresql-plpython3-14_14.0-1.pgdg110+1_amd64.deb.html 
> <https://debian.pkgs.org/11/postgresql-amd64/postgresql-plpython3-14_14.0-1.pgdg110+1_amd64.deb.html>:

This is the Debian project packages, not something the Postgres project 
controls.

The project does control this:

https://www.postgresql.org/download/linux/debian/

Which has the section

"Included in distribution"


that points out you may need to install additional packages.

This is also pointed out here:

https://www.postgresql.org/docs/current/plpython.html

"
Note

Users of source packages must specially enable the build of PL/Python 
during the installation process. (Refer to the installation instructions 
for more information.) Users of binary packages might find PL/Python in 
a separate subpackage.
"


> After that, I have successfully installed the extension and executed the 
> audit function

Does this mean everything is working now?

> 
> сб, 23 окт. 2021 г. в 09:04, Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>>:
> 
>     On 10/22/21 19:58, Дмитрий Иванов wrote:
>      > Good afternoon. Tell me what version of Python3 PostgreSQL 14 is
>      > targeting. I had problems with pairing version 12, working on 3.7.4
> 
>     1) Where did you install Postgres from?
> 
>     2) Define problems.
> 
>     3) To be clear you are trying to use plpython3u, correct?
> 
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



Re: Python3 for PostgreSQL 14

From
Дмитрий Иванов
Date:
Yes, it does. 
>If you used the EDB installer for the Windows install of Postgres then
>you need to use their Language Pack to match up with what the plpython
>expects.
It was obvious, but it didn't work. This is not a problem at the moment.

>This is the Debian project packages, not something the Postgres project
>controls.
>The project does control this:
>https://www.postgresql.org/download/linux/debian/
You may be right, but it didn't help me find the package postgresql-plpython3-14.
Yes everything works, thanks!

вс, 24 окт. 2021 г. в 01:40, Adrian Klaver <adrian.klaver@aklaver.com>:
On 10/23/21 13:00, Дмитрий Иванов wrote:
> Да.
> Python extension issues occurred on Windows Server 2012 and Windows 10
> Pro. Experimentally, when installing version 3.7.4, everything worked.

If you used the EDB installer for the Windows install of Postgres then
you need to use their Language Pack to match up with what the plpython
expects.

> This is my first time deploying Debian, and since I didn't want to
> deploy multiple versions, I asked a question. I have installed Python
> 3.10 x64. when faced with a lack of information on installing an
> extension pack, it would be a good idea to highlight this in the help.
> https://debian.pkgs.org/11/postgresql-amd64/postgresql-plpython3-14_14.0-1.pgdg110+1_amd64.deb.html
> <https://debian.pkgs.org/11/postgresql-amd64/postgresql-plpython3-14_14.0-1.pgdg110+1_amd64.deb.html>:

This is the Debian project packages, not something the Postgres project
controls.

The project does control this:

https://www.postgresql.org/download/linux/debian/

Which has the section

"Included in distribution"


that points out you may need to install additional packages.

This is also pointed out here:

https://www.postgresql.org/docs/current/plpython.html

"
Note

Users of source packages must specially enable the build of PL/Python
during the installation process. (Refer to the installation instructions
for more information.) Users of binary packages might find PL/Python in
a separate subpackage.
"


> After that, I have successfully installed the extension and executed the
> audit function

Does this mean everything is working now?

>
> сб, 23 окт. 2021 г. в 09:04, Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>>:
>
>     On 10/22/21 19:58, Дмитрий Иванов wrote:
>      > Good afternoon. Tell me what version of Python3 PostgreSQL 14 is
>      > targeting. I had problems with pairing version 12, working on 3.7.4
>
>     1) Where did you install Postgres from?
>
>     2) Define problems.
>
>     3) To be clear you are trying to use plpython3u, correct?
>
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

Re: Python3 for PostgreSQL 14

From
Magnus Hagander
Date:


On Sat, Oct 23, 2021 at 10:40 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 10/23/21 13:00, Дмитрий Иванов wrote:
> Да.
> Python extension issues occurred on Windows Server 2012 and Windows 10
> Pro. Experimentally, when installing version 3.7.4, everything worked.

If you used the EDB installer for the Windows install of Postgres then
you need to use their Language Pack to match up with what the plpython
expects.

> This is my first time deploying Debian, and since I didn't want to
> deploy multiple versions, I asked a question. I have installed Python
> 3.10 x64. when faced with a lack of information on installing an
> extension pack, it would be a good idea to highlight this in the help.
> https://debian.pkgs.org/11/postgresql-amd64/postgresql-plpython3-14_14.0-1.pgdg110+1_amd64.deb.html
> <https://debian.pkgs.org/11/postgresql-amd64/postgresql-plpython3-14_14.0-1.pgdg110+1_amd64.deb.html>:

This is the Debian project packages, not something the Postgres project
controls.

It is correct that the postgres project itself does not, but the Postgres debian packaging team packages both the packages for debian and those for apt.postgresql.org, so it's still the same people that does.

So there's actually a lot more crossover there than when you look at the EDB provided packages for example, where the team is completely indepdendent.

--