#!/bin/bash

# include variables
. ./variables

# export http_proxy
export http_proxy=${HTTP_PROXY}
export https_proxy=${HTTPS_PROXY}

# install packages
yum install -y postgresql-server

# init db
postgresql-setup initdb
echo "listen_addresses = '*'" >> /var/lib/pgsql/data/postgresql.conf
echo "host      dbname dbuser   172.17.0.0/16   md5" >> /var/lib/pgsql/data/pg_hba.conf
systemctl enable postgresql
systemctl start postgresql

# create db
su - -c "createdb --encoding=UTF-8 dbname --template=template0" postgres
#su - -c "createuser -P dbuser" postgres
su - -c "echo \"CREATE ROLE dbuser WITH LOGIN PASSWORD 'dbpass'\" | psql dbname" postgres
su - -c "echo 'grant all privileges on database dbname to dbuser' | psql dbname" postgres

# config firewall
firewall-cmd --change-interface docker0 --zone=trusted --permanent
firewall-cmd --reload