#!/bin/sh

set -eux

bailout () {
  if test -d /run/systemd/system; then
    systemctl stop pgagroal pgagroal.socket
  else
    sudo pkill pgagroal
  fi
}
trap bailout EXIT

if [ -z "$(pg_lsclusters -h)" ]; then
  version=$(ls /usr/lib/postgresql -v | tail -1)
  pg_createcluster $version main
fi

service postgresql start
PW=agroalpass
su -c "dropuser --if-exists agroaltestuser" postgres
su -c "( echo $PW; echo $PW ) | createuser --pwprompt agroaltestuser" postgres

if test -d /run/systemd/system; then
  systemctl stop pgagroal pgagroal.socket
  systemctl start pgagroal.socket
  export PGHOST=/run/postgresql
else
  su -c 'pgagroal' postgres &
  sleep 1
fi

PGPASSWORD=$PW psql -p 2345 -U agroaltestuser -c 'select 6*7' postgres | grep 42
