Dockerfile

FROM ubuntu:xenial

MAINTAINER vventirozos@omniti.com

### CHANGE THE FOLLOWING 3 PARAMETERS IF YOU WANNA CHANGE USER, POSTGRES INSTALL AND PGDATA DIRECTORIES ###

ENV PGUSER=postgres
ENV PGBINDIR=/home/$PGUSER/pgsql
ENV PGDATADIR=/home/$PGUSER/pgdata

#Installing packages and creating a OS user

RUN apt-get update && \
apt-get install -y \
	sudo wget apt-transport-https joe less build-essential \
	libreadline-dev zlib1g-dev flex bison libxml2-dev \
	libxslt-dev libssl-dev screen git unzip cpanminus && \
	useradd -c /home/$PGUSER -ms /bin/bash $PGUSER

#add user postgres to sudoers - SECURITY WARNING

run echo "$PGUSER ALL=(ALL) NOPASSWD:ALL" >> /etc/sudoers

run cpanm TAP::Parser::SourceHandler::pgTAP

# The next steps will run as postgres

USER $PGUSER
WORKDIR /home/$PGUSER
#getting the -latest- (ALWAYS) postgres version compile world and install

RUN wget https://www.postgresql.org/ftp/latest/ -q -O - |grep "tar.gz" |grep -v md5 |grep -v sha256 |awk -F "\"" '{print $2}' |xargs wget && \
	ls -1 *.tar.gz |xargs tar zxfv && \
	cd postgres* ; ./configure --prefix=$PGBINDIR ; make world ; make install-world

### Downloading pg_jobmon
RUN git clone https://github.com/omniti-labs/pg_jobmon/
RUN export PATH=$PATH:$PGBINDIR/bin && cd /home/$PGUSER/pg_jobmon/ && make && make install
RUN wget -c http://api.pgxn.org/dist/pgtap/1.1.0/pgtap-1.1.0.zip
RUN unzip pgtap-*
RUN export PATH=$PATH:$PGBINDIR/bin && cd pgtap-1.1.0 && make && make install

# PGDATA creation and initdb -WITH- data checksums

RUN mkdir $PGDATADIR && \
	$PGBINDIR/bin/initdb -k -D $PGDATADIR

# setting some postgres configurables

RUN echo "listen_addresses = '*'" >> $PGDATADIR/postgresql.conf && \
	echo "port = 5432" >> $PGDATADIR/postgresql.conf 

## Setting pg_hba.conf for passwordless access for all users and replication -- SECURITY WARNING

#install some extensions , create a replication user and a monkey database

RUN $PGBINDIR/bin/pg_ctl -D $PGDATADIR/ start ; sleep 10 && \
	$PGBINDIR/bin/psql -c "create extension dblink;" template1 && \
	$PGBINDIR/bin/psql -c "create extension pgtap;" template1 && \
	$PGBINDIR/bin/psql -c "create extension postgres_fdw;" template1 && \
	$PGBINDIR/bin/createdb monkey && \
	$PGBINDIR/bin/psql -c "CREATE SCHEMA jobmon;" monkey && \
	$PGBINDIR/bin/psql -c "CREATE extension pg_jobmon schema jobmon;" monkey && \
	$PGBINDIR/bin/psql -c "insert into jobmon.dblink_mapping_jobmon (username,port) values ('postgres','5432');" monkey && \
	$PGBINDIR/bin/pg_ctl -D $PGDATADIR/ -m fast stop

RUN echo "#!/bin/bash" > /home/$PGUSER/test_jobmon.sh && \
	echo "/home/$PGUSER/pgsql/bin/pg_ctl -D $PGDATADIR start" >>/home/$PGUSER/test_jobmon.sh && \
	echo "sleep 3" >>/home/$PGUSER/test_jobmon.sh && \
	echo "/usr/local/bin/pg_prove -b /home/$PGUSER/pgsql/bin/psql -f -v /home/postgres/pg_jobmon/test/test0* -d monkey" >>/home/$PGUSER/test_jobmon.sh && \
	chmod +x /home/$PGUSER/test_jobmon.sh

#USER root
CMD sudo service ssh restart && $PGBINDIR/bin/pg_ctl -D $PGDATADIR start && sleep 1  && tail -f /home/$PGUSER/pgdata/log/*.log
#Tadah !