Page History

...

1. Download the MADlib binary
   • For Postgres: OS X and Linux binaries can be found on the MADlib download page
   • For Greenplum: Linux .gppkg binaries can be found on Pivotal Network in the "Greenplum Advanced Analytics Group"
     • NOTE: the above .gppkg binaries work for both open and closed source Greenplum and can be downloaded by anybody (after creating a Pivotal Network account)
2. Install the package.
   
   1. Postgres:
      • on OSX double click the installer package

      • on Redhat / CentOS run the following as root:

        Code Block
        yum install <madlib_package> --nogpgcheck

        or

        Code Block
        language bash
        rpm -i <madlib_package>

        
        

   2. Greenplum:

      • on Redhat / CentOS run the following as gpadmin:

        Code Block
        language bash
        gppkg -i <madlib_package>

        
        

   3. NOTE: if you are using an rpm package on a CentOS 5 system, please add --no-deps flag to the command.
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 postgres 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.

4. Run the MADlib deployment utility to deploy 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

     
     

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

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

5. After installation gpadmin should grant all privileges on schema madlib to users who will be accessing MADlib functions. Otherwise, users will get "ERROR: permission denied for schema MADlib."  Also, install checks (see next step below) will fail if CREATE TEMP TABLE privileges are not granted on the schema where MADlib is installed. See the PostgreSQL docs for information on schemas and privileges.

6. Test your installation

...