Re: How to get plpython2 in /lib?

From: dpopova(at)uvic(dot)ca
To: "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>
Cc: dpopova(at)uvic(dot)ca, pgsql-general(at)postgresql(dot)org
Subject: Re: How to get plpython2 in /lib?
Date: 2015-03-07 05:43:40
Message-ID: 92cd5446a7d08e456f54bde6449774e4.squirrel@wm3.uvic.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)uvic(dot)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(at)uvic(dot)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(dot)klaver(at)aklaver(dot)com
>>>
>>
>>
>>
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arjen Nienhuis 2015-03-07 08:18:51 Re: Re: Re: [GENERAL] can postgresql supported utf8mb4 character sets?
Previous Message Tom Lane 2015-03-07 05:16:22 Re: VACUUM FULL doesn't reduce table size