Re: How to get plpython2 in /lib?

Adrian,

I again wiped out everything postgres from my machine (Mac 10.10.2,
Yosemite). Now, if I want to start installing postgres 9.3 anew, what is
the best way to go for it?
I found PostgresApp, that promises the easiest way to start using
postgres. Does it mean that if I install this PostgresApp for 9.3 (click
on the link), it will install and run postgres 9.3?
Or I must first install postgres 9.3 by other means and only after that I
can use PostgresApp for an easier access to postgres?

Confused,

Diana

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