Instructions for installing MADlib and Postgres on Ubuntu 14.04

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

See upgrade at https://gist.github.com/tqyq/955fcf2e505894d59db6b0e771cfe3e8