Hello All,
How do i enable plpython,plpython2u and plpython3u extensions all together in Leap 15.1 for postgresql11.5 !
Thanks
AFAICS, the plpython packages for postgresql version 11.5 are in the “experimental packages” repository which you should have used to install postgresql version 11.5:
- “server:database:postgresql
” – <https://build.opensuse.org/package/show/server%3Adatabase%3Apostgresql/postgresql11>.
[HR][/HR]When selecting such packages from the “openSUSE Software” packages, please make sure that, you select “Show postgresql11 for other distributions” – the “first up” buttons are only for Tumbleweed …
Yes, but most end users won’t be searching through OBS… They’ll likely be using the web package search tool
https://software.opensuse.org/package/postgresql11-plpython
And,
I wrote the following Wiki as a guide for User to find packages in general…
https://en.opensuse.org/User:Tsu2/Missing_Files_Dependencies
TSU
Thanks for your reply.
I installed that as below. But still i couldn’t manage to find plpython2u and plpythonu as below.
s151:~ # zypper in postgresql11-plpython-11.5-lp151.14.1.x86_64.rpm
Retrieving repository ‘Main Update Repository’ metadata …[done]
Building repository ‘Main Update Repository’ cache …[done]
Loading repository data…
Reading installed packages…
Resolving package dependencies…
The following 2 NEW packages are going to be installed:
postgresql-plpython postgresql11-plpython
The following recommended package was automatically selected:
postgresql11-plpython
2 new packages to install.
Overall download size: 232.7 KiB. Already cached: 0 B. After the operation, additional 795.6 KiB will be used.
Continue? [y/n/v/…? shows all options] (y): y
Retrieving package postgresql11-plpython-11.5-lp151.14.1.x86_64 (1/2), 221.1 KiB (795.5 KiB unpacked)
Retrieving package postgresql-plpython-11-lp151.13.35.noarch (2/2), 11.6 KiB ( 83 B unpacked)
Retrieving: postgresql-plpython-11-lp151.13.35.noarch.rpm …[done]
Checking for file conflicts: …[done]
(1/2) Installing: postgresql11-plpython-11.5-lp151.14.1.x86_64 …[done]
(2/2) Installing: postgresql-plpython-11-lp151.13.35.noarch …[done]
os151:~ #
os151:~ # cd /usr/share/postgresql11/extension/
os151:/usr/share/postgresql11/extension # ls -lhtr | grep python
-rw-r–r-- 1 root root 194 Sep 14 00:49 ltree_plpythonu.control
-rw-r–r-- 1 root root 423 Sep 14 00:49 ltree_plpythonu–1.0.sql
-rw-r–r-- 1 root root 197 Sep 14 00:49 ltree_plpython3u.control
-rw-r–r-- 1 root root 449 Sep 14 00:49 ltree_plpython3u–1.0.sql
-rw-r–r-- 1 root root 197 Sep 14 00:49 ltree_plpython2u.control
-rw-r–r-- 1 root root 449 Sep 14 00:49 ltree_plpython2u–1.0.sql
-rw-r–r-- 1 root root 188 Sep 14 00:49 jsonb_plpythonu.control
-rw-r–r-- 1 root root 682 Sep 14 00:49 jsonb_plpythonu–1.0.sql
-rw-r–r-- 1 root root 191 Sep 14 00:49 jsonb_plpython3u.control
-rw-r–r-- 1 root root 732 Sep 14 00:49 jsonb_plpython3u–1.0.sql
-rw-r–r-- 1 root root 191 Sep 14 00:49 jsonb_plpython2u.control
-rw-r–r-- 1 root root 732 Sep 14 00:49 jsonb_plpython2u–1.0.sql
-rw-r–r-- 1 root root 198 Sep 14 00:49 hstore_plpythonu.control
-rw-r–r-- 1 root root 698 Sep 14 00:49 hstore_plpythonu–1.0.sql
-rw-r–r-- 1 root root 201 Sep 14 00:49 hstore_plpython3u.control
-rw-r–r-- 1 root root 750 Sep 14 00:49 hstore_plpython3u–1.0.sql
-rw-r–r-- 1 root root 201 Sep 14 00:49 hstore_plpython2u.control
-rw-r–r-- 1 root root 750 Sep 14 00:49 hstore_plpython2u–1.0.sql
-rw-r–r-- 1 root root 196 Sep 14 01:30 plpython3u.control
-rw-r–r-- 1 root root 402 Sep 14 01:30 plpython3u–unpackaged–1.0.sql
-rw-r–r-- 1 root root 351 Sep 14 01:30 plpython3u–1.0.sql
os151:/usr/share/postgresql11/extension #
os151:~ # rpm -qa | grep post
postgresql11-contrib-11.5-lp151.14.1.x86_64
postgresql11-plpython-11.5-lp151.14.1.x86_64
postgresql11-devel-11.5-lp151.14.1.x86_64
postgresql11-server-devel-11.5-lp151.14.1.x86_64
postgresql-contrib-11-lp151.13.35.noarch
postgresql11-11.5-lp151.14.1.x86_64
postgresql11-server-11.5-lp151.14.1.x86_64
postgresql-plperl-11-lp151.13.35.noarch
postgresql-plpython-11-lp151.13.35.noarch
postgresql-server-11-lp151.13.35.noarch
postgresql-11-lp151.13.35.noarch
postgresql11-plperl-11.5-lp151.14.1.x86_64
postfix-3.3.1-lp151.1.48.x86_64
os151:~ #
Can you please advise how do i proceed to get all version of plpythonu. Thanks
Yes, tsu2 is correct, you should be searching for the plpython, plpython2u and plpython3u suited for postgresql11 via: <https://software.opensuse.org/package/postgresql11-plpython>.
Which repository did you use to install postgresql11-plpython?
- Use “zypper info postgresql11-plpython
”, and please post the output of the line beginning “Repository”.
You could check which files are installed by the postgresql11-plpython package: “rpm -ql postgresql11-plpython”.
[HR][/HR]I suspect that, the openSUSE PostgreSQL Releases 10 and 11 packages only support the Python 3 extensions – but, I could be wrong …
Which repository did you use to install postgresql11-plpython?
- Use “zypper info postgresql11-plpython
”, and please post the output of the line beginning “Repository”.
You could check which files are installed by the postgresql11-plpython package: “rpm -ql postgresql11-plpython”.
Here is the output:
os151:~ # zypper info postgresql11-plpython
Retrieving repository ‘Main Update Repository’ metadata …[done]
Building repository ‘Main Update Repository’ cache …[done]
Loading repository data…
Reading installed packages…
Information for package postgresql11-plpython:
Repository : @System
Name : postgresql11-plpython
Version : 11.5-lp151.14.1
Arch : x86_64
Vendor :
Installed Size : 795.5 KiB
Installed : Yes
Status : up-to-date
Source package : postgresql11-11.5-lp151.14.1.src
Summary : The PL/Python Procedural Languages for PostgreSQL
os151:~ # rpm -ql postgresql11-plpython
/usr/lib/postgresql11/lib64/plpython3.so
/usr/share/locale/cs/LC_MESSAGES/plpython-11.mo
/usr/share/locale/de/LC_MESSAGES/plpython-11.mo
/usr/share/locale/es/LC_MESSAGES/plpython-11.mo
/usr/share/locale/fr/LC_MESSAGES/plpython-11.mo
/usr/share/locale/it/LC_MESSAGES/plpython-11.mo
/usr/share/locale/ja/LC_MESSAGES/plpython-11.mo
/usr/share/locale/ko/LC_MESSAGES/plpython-11.mo
/usr/share/locale/pl/LC_MESSAGES/plpython-11.mo
/usr/share/locale/pt_BR/LC_MESSAGES/plpython-11.mo
/usr/share/locale/ru/LC_MESSAGES/plpython-11.mo
/usr/share/locale/sv/LC_MESSAGES/plpython-11.mo
/usr/share/locale/tr/LC_MESSAGES/plpython-11.mo
/usr/share/locale/vi/LC_MESSAGES/plpython-11.mo
/usr/share/locale/zh_CN/LC_MESSAGES/plpython-11.mo
/usr/share/postgresql11/extension/plpython3u–1.0.sql
/usr/share/postgresql11/extension/plpython3u–unpackaged–1.0.sql
/usr/share/postgresql11/extension/plpython3u.control
os151:~ #
[HR][/HR]I suspect that, the openSUSE PostgreSQL Releases 10 and 11 packages only support the Python 3 extensions – but, I could be wrong …[/QUOTE]
i think so.
Thanks for your reply and waiting for your response.
Do you really need to install and build Python 2 and Python3 versions?
If so, then of course you’ll need to install Python 2.
And, any python packages not available in LEAP 15.1 is likely available in the PyPi repos (The official Python repositories).
TSU
Thanks for your reply.
FYI:
os151:~ # rpm -qa | grep python
python-base-2.7.14-lp151.10.7.1.x86_64
python-devel-2.7.14-lp151.10.7.1.x86_64
samba-libs-python3-4.9.5+git.149.9593f64a5c3-lp151.1.3.x86_64
python3-packaging-16.8-lp151.2.1.noarch
python3-pip-10.0.1-lp151.2.2.noarch
postgresql11-plpython-11.5-lp151.14.1.x86_64
python3-talloc-2.1.14-lp151.1.1.x86_64
python3-apparmor-2.12.2-lp151.3.2.x86_64
libpython3_6m1_0-3.6.5-lp151.5.2.x86_64
yast2-python3-bindings-4.1.0-lp151.1.1.x86_64
libsamba-policy0-python3-4.9.5+git.149.9593f64a5c3-lp151.1.3.x86_64
python3-pyparsing-2.2.0-lp151.2.1.noarch
python3-curses-3.6.5-lp151.5.1.x86_64
python3-urwid-2.0.1-lp151.2.5.x86_64
python3-ldb-1.4.6-lp151.1.1.x86_64
python3-base-3.6.5-lp151.5.2.x86_64
python3-appdirs-1.4.3-lp151.2.1.noarch
python3-3.6.5-lp151.5.1.x86_64
python3-dbm-3.6.5-lp151.5.1.x86_64
python3-gobject-3.26.1-lp151.2.3.x86_64
python3-tevent-0.9.37-lp151.1.1.x86_64
python3-pyudev-0.21.0-lp151.4.2.noarch
python3-decorator-4.2.1-lp151.2.2.noarch
samba-python3-4.9.5+git.149.9593f64a5c3-lp151.1.3.x86_64
python2-six-1.11.0-lp151.3.1.noarch
python3-bind-9.11.2-lp151.10.1.noarch
python-rpm-macros-20190408.32abece-lp151.1.1.noarch
python3-solv-0.7.3-lp151.1.1.x86_64
python3-setuptools-40.5.0-lp151.1.1.noarch
python3-tdb-1.3.16-lp151.1.2.x86_64
python3-ply-3.10-lp151.2.1.noarch
python3-configobj-5.0.6-lp151.2.1.noarch
python3-firewall-0.5.5-lp151.5.1.noarch
python-2.7.14-lp151.10.7.1.x86_64
postgresql-plpython-11-lp151.13.35.noarch
python3-pycurl-7.43.0.2-lp151.1.1.x86_64
python3-pycups-1.9.73-lp151.2.4.x86_64
python3-six-1.11.0-lp151.3.1.noarch
python3-rpm-4.14.1-lp151.13.10.x86_64
python3-cupshelpers-1.5.7-lp151.6.3.noarch
python3-zypp-plugin-0.6.3-lp151.2.1.noarch
python3-linux-procfs-0.6-lp151.1.1.noarch
python3-dbus-python-1.2.4-lp151.5.3.x86_64
python3-slip-dbus-0.6.5-lp151.5.1.noarch
libpython2_7-1_0-2.7.14-lp151.10.7.1.x86_64
python-dateutil-2.1-lp150.8.1.noarch
python3-slip-0.6.5-lp151.5.1.noarch
os151:~ #
Above python related packages were installed on my machine. Still i have plpython3u only under PSQL extension.
Thanks
Only python3 (3u) packages on your machine is likely unsurprising since for several years now there has been a very slow move to deprecate python 2 not too quickly.
So, there are ways like I described how to install Python 2 versions but the question is whether you really need those versions… Unless you’re running something provided by others in multiple versions (and why would that be the case?) you’d probably need one version or the other… Unless maybe you want to write something that should be made available for both python versions.
What is your need? That should determine what you should do.
TSU