THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
Table of Contents
To set up PostgreSQL and MADlib with Anaconda Python on OSX, follow the super quick start.
...
To set up PostgreSQL + MADLib with Anaconda Python on OSX:
| Code Block |
|---|
PYTHON=/Users/janedoe/anaconda/bin/python brew install postgresql --with-python brew services start postgresql — — Set up database and roles — — Install the .dmg of madlib 1.9.1 downloaded from MADlib website /usr/local/madlib/bin/madpack -s madlib -p postgres install |
...
- Ensure that you install Postgres with the Python extension specified --with-python, as meter as described here in the PosgreSQL documentation. If not you will see an error message like the one below:
| Code Block |
|---|
/usr/local/madlib/bin/madpack -s madlib -p postgres install madpack.py : INFO : Detected PostgreSQL version 9.5. madpack.py : INFO : *** Installing MADlib *** madpack.py : INFO : MADlib tools version = 1.9.1 (//usr/local/madlib/Versions/1.9.1/bin/../madpack/madpack.py) madpack.py : INFO : MADlib database version = None (host=localhost:5432, db=postgres, schema=madlib) 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. |
To install PostgreSQL with PL/Python server-side language, use the ```--with-python``` parameter as described here in the PosgreSQL documentation.
- If environment variables If the environment variables listed below are defined, this it can save you some typing.
...