To set up PostgreSQL and MADlib with Anaconda Python on OSX, follow the super quick start.

Otherwise, follow the This is a quick start guide for installing from binaries or compiling from source for MADlib^®.

Please note that a Greenplum database sandbox VM with MADlib pre-installed is also available to get started quickly, as an alternative to following the installation steps described on this page.

Anchor
Super Quick Start Super Quick Start

Super Quick Start

To set up PostgreSQL + MADLib with Anaconda Python on OSX:

Anchor
Quick Start With Binaries Quick Start With Binaries

Quick Start With Binaries

...

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

PYTHON=/Users/qshao/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

• If environment variables are defined, this can save you some typing.

...