Skip to content

Instantly share code, notes, and snippets.

@jvawdrey
Last active December 4, 2022 17:34
Show Gist options
  • Save jvawdrey/9656536937772d208c0e8ea5205f905b to your computer and use it in GitHub Desktop.
Save jvawdrey/9656536937772d208c0e8ea5205f905b to your computer and use it in GitHub Desktop.
Instructions for installing MADlib and Postgres on Ubuntu 14.04

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
@njitsilence
Copy link

sadly wget "http://bitcast-a.v1.o1.sjc1.bitgravity.com/greenplum/MADlib/files/madlib-1.6-Linux.rpm" just 404
can you pls tell me any link can use ,thanks a lot

@ppKrauss
Copy link

ppKrauss commented Dec 4, 2022

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment