Re: How to get plpython2 in /lib? - Mailing list pgsql-general

From dpopova@uvic.ca
Subject Re: How to get plpython2 in /lib?
Date
Msg-id 92cd5446a7d08e456f54bde6449774e4.squirrel@wm3.uvic.ca
Whole thread Raw
In response to Re: How to get plpython2 in /lib?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: How to get plpython2 in /lib?
Re: How to get plpython2 in /lib?
List pgsql-general
Thank you, Adrian.
Maybe, you will be able to find something useful.
I spent more hours trying to
- install PostgreSQL 9.3 (successful, but with python3)
- install PostgresApp 9.3 (unsuccessful, could not start postgres,  but no
matter - no python2 there anyway), then uninstall it.
- install Python 2.7 (successful)

MADlib still cannot be registered - same failure, with no plpython2 found
in /lib:

madpack.py : INFO : Testing PL/Python environment...
madpack.py : INFO : > Creating language PL/Python...
madpack.py : ERROR : SQL command failed:
SQL: CREATE LANGUAGE plpythonu;
ERROR:  could not access file "$libdir/plpython2": No such file or directory

madpack.py : ERROR : Cannot create language plpythonu. Stopping
installation...
madpack.py : ERROR : MADlib installation failed.

Sad,  :-(

Diana

> On 03/06/2015 05:41 PM, dpopova@uvic.ca wrote:
>> Postgres installed with Installer, from EnterpriseDB.
>> Error received while trying to register MADlib 1.7.0.
>
> I seem to remember the EDB builds against Python 3 not 2 now, which
> would explain the error below if MADlib is looking for Python 2. I
> cannot remember if there is a work around, will dig into further.
>
>>
>> Looked at PostgresApp, but it is a package for PostgreSQL 9.4. Cannot
>> have
>> this version of Postgres, because it is not supported by MADlib. Tried,
>> does not work. Had to uninstall, + manual deletion of a number of
>> 'leftovers'. :-(
>
> According to here:
>
> https://github.com/madlib/madlib/wiki/Installation-Guide
>
> it should work with 9.2+.
>
>
> There is 9.3 version of PostgresApp available here:
>
> https://github.com/PostgresApp/PostgresApp/releases
>
>>
>> Need MADlib for research. Please, help.
>>
>> Diana
>>
>>
>>> On 03/06/2015 12:44 PM, dpopova@uvic.ca wrote:
>>>> Mac 10.10.2 (Yosemite)
>>>> PostgreSQL 9.3
>>>>
>>>> error message:
>>>> ERROR : SQL command failed:   SQL: CREATE LANGUAGE plpythonu;
>>>> ERROR:  could not access file "$libdir/plpython2": No such file or
>>>> directory
>>>>
>>>> Searched Web, nothing useful found...
>>>>
>>>> Any advice will be greatly appreciated.
>>>
>>> How was Postgres installed?
>>>
>>> What where you doing to get the error?
>>> Doing a pg_restore from another database?
>>> Running CREATE LANGUAGE/EXTENSION directly?
>>>
>>>
>>>>
>>>> Diana
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Adrian Klaver
>>> adrian.klaver@aklaver.com
>>>
>>
>>
>>
>>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: VACUUM FULL doesn't reduce table size
Next
From: Arjen Nienhuis
Date:
Subject: Re: Re: Re: [GENERAL] can postgresql supported utf8mb4 character sets?