Warning, file /sdk/codevis/thirdparty/soci/scripts/vagrant/postgresql.sh was not indexed or was modified since last indexation (in which case cross-reference links may be missing, inaccurate or erroneous).
0001 #!/usr/bin/env bash 0002 # Part of Vagrant virtual development environments for SOCI 0003 0004 # Installs PostgreSQL with 'soci' user and database 0005 # Pre-installation 0006 source /vagrant/scripts/vagrant/common.env 0007 export DEBIAN_FRONTEND="noninteractive" 0008 # Installation 0009 sudo apt-get -o Dpkg::Options::='--force-confnew' -y -q install \ 0010 postgresql \ 0011 postgresql-contrib 0012 # Post-installation 0013 echo "PostgreSQL: updating /etc/postgresql/9.3/main/postgresql.conf" 0014 sudo sed -i "s/#listen_address.*/listen_addresses '*'/" /etc/postgresql/9.3/main/postgresql.conf 0015 echo "PostgreSQL: updating /etc/postgresql/9.3/main/pg_hba.conf" 0016 sudo cat >> /etc/postgresql/9.3/main/pg_hba.conf <<EOF 0017 # Accept all IPv4 connections - DEVELOPMENT ONLY 0018 host all all 0.0.0.0/0 md5 0019 EOF 0020 echo "PostgreSQL: creating user ${SOCI_USER}" 0021 sudo -u postgres psql -c "CREATE ROLE ${SOCI_USER} WITH LOGIN SUPERUSER CREATEDB ENCRYPTED PASSWORD '${SOCI_PASS}'" 0022 echo "PostgreSQL: creating database ${SOCI_USER}" 0023 sudo -u postgres dropdb --if-exists ${SOCI_USER} 0024 sudo -u postgres createdb ${SOCI_USER} --owner=${SOCI_USER} 0025 echo "PostgreSQL: restarting" 0026 sudo service postgresql restart 0027 echo "PostgreSQL: DONE"