install pg 9.5 on semaphore

pg-setup.sh

#!/usr/bin/env bash

set -e

pg_version=${1:-'9.5'}

echo "Installing PostgreSQL version: $pg_version"

sudo apt-get update -q
sudo apt-get -y install postgresql-client-$pg_version postgresql-$pg_version postgresql-contrib-$pg_version postgresql-server-dev-$pg_version libpq-dev postgresql-$pg_version-postgis-2.2

sudo su postgres <<CMD
psql -c "ALTER USER postgres" -d template1;
psql -c "CREATE USER runner WITH PASSWORD 'semaphoredb';" -d template1;
psql -c "ALTER USER runner CREATEUSER CREATEDB;" -d template1;
psql -c "CREATE EXTENSION hstore WITH SCHEMA pg_catalog;" -d template1;
CMD