xenefix
5/15/2018 - 7:41 PM

Ubuntu 16.04 PHP+Apache+Postgres9.5

#!/bin/bash
# setup LAPP server with
# pg admin postgres | postgrespw
# try with `export PGPASSWORD='postgrespw'; psql -h <serverip> -U postgres`

export DEBIAN_FRONTEND=noninteractive
export DEBIAN_PRIORITY=critical
sudo -E apt-get -qy update
sudo -E apt-get -qy -o "Dpkg::Options::=--force-confdef" -o "Dpkg::Options::=--force-confold" upgrade
sudo -E apt-get -qy autoclean

apt install \
      apache2 \
      php \
      php-pgsql \
      libapache2-mod-php \
      php-xml \
      php-mbstring \
      postgresql \
      postgresql-client \
      -qq -y --no-install-recommends
sudo /etc/init.d/apache2 restart
echo "listen_addresses = '*'" >> /etc/postgresql/9.5/main/postgresql.conf
cd /
sudo -u postgres psql template1 -c "ALTER USER postgres with encrypted password 'postgrespw';"
echo "host    all             all              0.0.0.0/0                       md5" >> /etc/postgresql/9.5/main/pg_hba.conf
echo "host    all             all              ::/0                            md5" >> /etc/postgresql/9.5/main/pg_hba.conf

sudo systemctl restart postgresql.service