Postgres94 Install

sudo apt-get install -y git build-essential gettext libreadline6 libreadline6-dev zlib1g-dev flex bison libxml2-dev libxslt-dev

test -d postgresql || git clone --depth=1 git://git.postgresql.org/git/postgresql.git postgresql

PROJECT_PATH=`pwd`

PG_PATH=`pwd`/build

cd postgresql

export XML2_CONFIG=`which xml2-config`
./configure --prefix=$PG_PATH  --with-libxml
make
make install

cd ..

# COPY THIS to .bashrc or .zshrc
export PATH=$PATH:$PG_PATH/bin
export PGDATA=`pwd`/data

test -d $PGDATA || initdb -D $PGDATA

pg_ctl -D $PGDATA start


# build pgcrypto

cd postgresql/contrib/pgcrypto
make
make install
make installcheck

createuser -s fhir
psql -d postgres -E '\password fhir'

# build jsquery

cd $PROJECT_PATH

git clone  [email protected]:akorotkov/jsquery.git postgresql/contrib/jsquery
cd postgresql/contrib/jsquery
make
make install
make installcheck