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, dpop...@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, dpop...@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.kla...@aklaver.com >>>> >>> >>> >>> >>> >> >> >> -- >> Adrian Klaver >> adrian.kla...@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 >> > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
