jvawdrey/madlib-postgres-ubuntu.md

## madlib-postgres-ubuntu.md

      
    Raw
  

              madlib-postgres-ubuntu.md
            
          
    madlib-postgres-ubuntu

Instructions for installing MADlib and Postgres on Ubuntu 14.04
# Install Postgres 9.3, pl/r and dependencies for MADlib
sudo apt-get install -y cmake postgresql-9.3 postgresql-server-dev-9.3 postgresql-plpython-9.3 postgresql-9.3-plr libkrb5-dev postgresql-client postgresql-contrib

# grab madlib rpm
cd /home/gpadmin/tmp
wget "http://bitcast-a.v1.o1.sjc1.bitgravity.com/greenplum/MADlib/files/madlib-1.6-Linux.rpm"

# install ubuntu package alien
sudo apt-get install -y alien

# convert madlib rpm to deb
alien madlib-1.6-Linux.rpm --scripts

# run deb
dpkg -i madlib_1.6-2_amd64.deb

# setup username and password
sudo -u postgres psql postgres
\password postgres
\q

# add languages to postgres
sudo -u postgres psql postgres
psql
CREATE EXTENSION plpythonu;
CREATE EXTENSION plr;
\q

# run madpack
/usr/local/madlib/bin/madpack -p postgres -c postgres@localhost:5432/postgres install