Installation Guide on PostgreSQL (v0.1.0alpha)

Prerequisites:

The following software must be installed before proceeding with the Installation Steps:

• Database: PostgreSQL 8.2 or higher
• Other software: LAPACK-DEVEL (http://www.netlib.org/lapack/)

Installation Steps:

These instructions assume your database is installed in $PGHOME (example: /Library/PostgreSQL/9.0), and you have sudo access to the database installation user account (default: postgres).

1. Login to the server using postgres account and add $PGHOME/bin to your PATH.

2. Prepare your database and schema designated for MADlib installation:

   a) If the database does not exist, create it:

     $> createdb <db_name>

b) Create target schema (default: madlib): 

     sql> CREATE SCHEMA <schema_name>;  

c) Create database languages: 

     sql> CREATE LANGUAGE plpgsql;  
     sql> CREATE LANGUAGE plpythonu;  

3. Make sure you have Python setuptools installed:

     $> cd /tmp
     $> wget http://pypi.python.org/packages/2.6/s/setuptools/setuptools-0.6c11-py2.6.egg#md5=bfa92100bd772d5a213eedd356d64086
     $> sh setuptools-0.6c11-py2.6.egg

Note!: If you are using a Mac you are probably missing wget. You can either install it or just copy the above link to your browser and download setuptools egg file. Then go to the download directory and run sh setuptools-0.6c11-py2.6.egg.

4. Install the following python libraries used by the madlib installer.

     $> easy_install argparse sqlparse hashlib pygresql

Note!: If you notice an error during hashlib module installation just ignore it.

5. Download and uncompress madlib repository from https://github.com/madlib/madlib/archives/master or use git to clone it from [email protected]:madlib/madlib.git.

6. Change directory to the madlib root and edit the madpy/Config.yml file to reflect your installation:

     $> vi madpy/Config.yml

* Note #1: Make sure to verify `connect_args`.
* Note #2: Set `target_schema` according to step 2b).

7. From the madlib directory run the Python install command. This step deploys MADlib libraries into the target directories:

     $> python setup.py install

8. Now that the python libraries are installed and the database is ready, it's time to build the database extensions and install them:

     $> export C_INCLUDE_PATH=$PGHOME/include/
     $> madpack install

9. To test your installation you can run the following command to list all the functions installed in your MADlib designated schema:

     psql -d <db_name> -c "\df <schema_name>.*"

10. Done. Visit MADlib User Documentation for more info.