Обсуждение: Python3 for PostgreSQL 14
Good afternoon. Tell me what version of Python3 PostgreSQL 14 is targeting. I had problems with pairing version 12, working on 3.7.4
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
Да.
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
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
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.
>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/
>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
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.