Drone.io Install Postgres9.4

install.sh

#!/bin/bash

# remove existing 9.3 installation
sudo /etc/init.d/postgresql stop
sudo apt-get --force-yes -fuy remove --purge postgresql postgresql-9.1 postgresql-client

# install 9.4
sudo apt-get install python-software-properties
sudo add-apt-repository 'deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main 9.4'
sudo apt-get update
sudo apt-get install -y postgresql-client-9.4 postgresql-9.4

# update the postgres config files
sudo /bin/bash -c "cat <<EOF > /etc/postgresql/9.4/main/pg_hba.conf
local   all             postgres                                trust
local   all             all                                     trust
host    all             all             127.0.0.1/32            trust
host    all             all             ::1/128                 trust
EOF"

initdb

# restart
sudo /etc/init.d/postgresql restart

Usage (in your drone.io Settings/Build & Test/Commands:

curl --silent https://gist.githubusercontent.com/schinckel/cc3f4d6067458f935ae3/raw/70c6e69f52dedc838167673221b30003e8dee61c/install.sh | /bin/bash -s 1> /dev/null 2> /dev/null