...

• PostgreSQL
• Greenplum database
• Pivotal HDB/Apache HAWQ (incubating)

...

• )

Postgres platform notes:

• Ensure that you install Postgres with the Python extension specified.
• If environment variables are defined, this can save you some typing.

...

1. Download the MADlib binary
   • Postgres: Get either the OSX or Redhat/CentOS binary from the MADlib download page
   • Pivotal Greenplum Databasedatabase and HDB/HAWQ : Download the .gppkg binary from Pivotal Network
     
     

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

...

• Greenplum Database:

  • on Redhat / CentOS run the following as gpadmin:

    Code Block
    language bash
    gppkg install <madlib_package>

• HDB/HAWQ:

  • on Redhat / CentOS run the following as gpadmin:

    Code Block
    language bash
    gppkg install <madlib_package>

1. 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 pg_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.
      

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

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

   • HDB/HAWQ:

     Code Block
     language bash
     /usr/local/madlib/bin/madpack –p hawq 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

   Help output is also attached to this wiki page for your reference.

   
   

3. Test your installation

1. • Postgres:

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

   • Pivotal Greenplum Database:

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

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

   • HDB/HAWQ:

     Code Block
     language bash
     /usr/local/madlib/bin/madpack –p hawq install-check

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

Anchor
Compile From Source Compile From Source

Compiling From Source

...

• gcc (For OSX, Clang will work for compiling the source, but not for documentation.)
• An installed version of HDB/HAWQ, Greenplum Database 4.2+ or Postgre PostgreSQL (64-bit) 9.2+ with plpython support enabled. Note: plpython may not be enabled in Postgres by default.

...