Results 1 to 9 of 9

Thread: postgresql11.5 - plpython

  1. #1

    Default postgresql11.5 - plpython

    Hello All,

    How do i enable plpython,plpython2u and plpython3u extensions all together in Leap 15.1 for postgresql11.5 !

    Thanks

  2. #2
    Join Date
    Feb 2010
    Location
    Germany
    Posts
    2,559

    Exclamation Re: postgresql11.5 - plpython

    @ramkumarcrk19:

    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:


    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 …

  3. #3
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,371
    Blog Entries
    2

    Default Re: postgresql11.5 - plpython

    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/packag...sql11-plpython

    And,
    I wrote the following Wiki as a guide for User to find packages in general...
    https://en.opensuse.org/User:Tsu2/Mi...s_Dependencies

    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  4. #4

    Default Re: postgresql11.5 - plpython

    Quote Originally Posted by dcurtisfra View Post
    @ramkumarcrk19:

    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:


    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 …
    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

  5. #5
    Join Date
    Feb 2010
    Location
    Germany
    Posts
    2,559

    Question Re: postgresql11.5 - plpython

    @ramkumarcrk19:

    Yes, tsu2 is correct, you should be searching for the plpython, plpython2u and plpython3u suited for postgresql11 via: <https://software.opensuse.org/packag...sql11-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”.

    I suspect that, the openSUSE PostgreSQL Releases 10 and 11 packages only support the Python 3 extensions – but, I could be wrong

  6. #6

    Default Re: postgresql11.5 - 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”.

    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:~ #






    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.

  7. #7
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,371
    Blog Entries
    2

    Default Re: postgresql11.5 - plpython

    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
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  8. #8

    Default Re: postgresql11.5 - plpython

    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

  9. #9
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,371
    Blog Entries
    2

    Default Re: postgresql11.5 - plpython

    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
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •