...

1. Download the MADlib binary
   • Postgres: Get either the OSX or Redhat/CentOS binary from the MADlib download page
   • Pivotal Greenplum Database: Download the .gppkg binary from Pivotal Network
     
     
2. Install the package at the OS level.
   • Postgres:
     • on OSX double click the installer package

     • on Redhat / CentOS run the following as root:

       Code Block
       yum install <madlib_package> --nogpgcheck

   • Pivotal Greenplum Database:

     • on Redhat / CentOS run the following as gpadmin:

       Code Block
       language bash
       gppkg install <madlib_package>

3. Ensure that the environment is setup for your database deployment and that the database is up and running.

   • Ensure that psql, postgres, and pg_config are in your path

     Code Block
     language bash
     which psql which postgres which pgconfigpg_config

   • Ensure that the database is started and running

     Code Block
     language bash
     psql -c 'select version()'

     The above may need user/port/password setting depending on how the database has been configured.
      

4. Run the MADlib deployment utility to install MADlib into each database that you want to use it in:
   

   • Postgres:

     Code Block
     language bash
     /usr/local/madlib/bin/madpack -s madlib –p postgres install

     if environment variables are defined. Otherwise use a fully defined connection string:

     Code Block
     language bash
     /usr/local/madlib/bin/madpack -s madlib -p postgres -c [user[/password]@][host][:port][/database] install

   • Pivotal Greenplum Database:

     Code Block
     language bash
     /usr/local/madlib/bin/madpack –p greenplum install

     The above may need user/port/password setting depending on how the database has been configured.

   For more information on madpack:

   Code Block
   language bash
   /usr/local/madlib/bin/madpack --help

    

5. Test your installation

...

Installing MADlib

In the $MADLIB_ROOT directory (location of MADlib source) run the following commands:

mkdir build 
cd build 
cmake .. 
make

...

Deploy MADlib into the database with MADlib package manager madpack located under $BUILD_ROOT/src/bin.

• To install:

  Code Block
  language bash
  $BUILD_ROOT/src/bin/madpack -p postgres -c [user[/password]@][host][:port][/database] install

• To make sure that the installation is successful:

  Code Block
  language bash
  $BUILD_ROOT/src/bin/madpack -p postgres -c [user[/password]@][host][:port][/database] install-check

• For more information on the usage of madpack:
  

  Code Block
  language bash
  $BUILD_ROOT/src/bin/madpack --help

Anchor
Env variables Env variables

Defining environment variables

The variables below variables will be automatically used by the madpack installer if no connection string is provided.:

1. User: PGUSER or USER (defaults to OS username)
2. Password: PGPASSWORD (defaults to empty)
3. Host: PGHOST (defaults to 'localhost')
4. Database: PGDATABASE (defaults to OS username)
5. Port: PGPORT (defaults to 5432)

...