Re: could not load library "$libdir/plpython2" while upgrading from postgresql-10 to 12

Holger Jakobs <holger@xxxxxxxxxx> · Fri, 5 Mar 2021 09:59:34 +0100



    Hi,
    Since Python2 is totally deprecated, you'll have to use Python3.
    postgresql-plpython3-12 - PL/Python 3 procedural language for
      PostgreSQL 12

    
    Regards,
    Holger

    
    Am 05.03.21 um 08:03 schrieb RAJAMOHAN:

    
      Hello all,
        

        I am getting the below error while trying to upgrade from 
          postgres 10 to 12 version on ubuntu machine.  It
          seems plpython2 is not installed for the postgresql-12
          version.
        

        could not load library "$libdir/plpython2": ERROR:
             could not access file "$libdir/plpython2": No such file or
            directory

          
         I tried to install it using the below command, but it was
          not successful. Whether I need to migrate the functions in
          postgres-10 instance to plpython3 and try upgrading OR Is
          there any other way to install the package for postgresql-12
          version?
        

        apt install postgresql-plpython-12

          Reading package lists... Done

          Building dependency tree       

          Reading state information... Done

          E: Unable to locate package postgresql-plpython-12

        
        OS details:
          Operating System: Ubuntu 18.04.1 LTS

                      Kernel: Linux 5.4.0-1035-aws

                Architecture: x86-64

        
                  Thanks & Regards,
                  Raj
                  

    -- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
  

Attachment:
OpenPGP_signature

Description: OpenPGP digital signature