diff options
Diffstat (limited to 'vagrant_scripts/pg93_bootstrap.sh')
| -rwxr-xr-x | vagrant_scripts/pg93_bootstrap.sh | 15 |
1 files changed, 4 insertions, 11 deletions
diff --git a/vagrant_scripts/pg93_bootstrap.sh b/vagrant_scripts/pg93_bootstrap.sh index 345d5ce..57d5efa 100755 --- a/vagrant_scripts/pg93_bootstrap.sh +++ b/vagrant_scripts/pg93_bootstrap.sh @@ -12,17 +12,18 @@ export LANGUAGE="en_US.UTF-8" export LANG="en_US.UTF-8" export LC_ALL="en_US.UTF-8" -echo "deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main" > /etc/apt/sources.list.d/pgdg.list +echo "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main" > /etc/apt/sources.list.d/pgdg.list wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add - apt-get --yes update apt-get --yes upgrade -apt-get --yes --force-yes install postgresql-9.3 postgresql-contrib-9.3 s3cmd +apt-get --yes --force-yes install postgresql-9.3 postgresql-contrib-9.3 postgresql-9.3-pgpool2 pg_dropcluster --stop 9.3 main echo "listen_addresses = '*'" >> /etc/postgresql-common/createcluster.conf echo "max_connections = 500" >> /etc/postgresql-common/createcluster.conf pg_createcluster --start -e UTF-8 --locale en_US.UTF-8 9.3 main -- --auth-local=trust -echo "host all all 10.0.0.0/16 md5" >> /etc/postgresql/9.3/main/pg_hba.conf +echo "host all all 10.0.0.14/32 md5" >> /etc/postgresql/9.3/main/pg_hba.conf +echo "host all all 10.0.0.24/32 md5" >> /etc/postgresql/9.3/main/pg_hba.conf echo "host all all 192.168.50.0/24 md5" >> /etc/postgresql/9.3/main/pg_hba.conf service postgresql reload @@ -33,11 +34,3 @@ iptables -A INPUT -p tcp --dport 5432 -j ACCEPT psql -U postgres postgres < /vagrant/src/main/resources/db/postgresql/initial_setup.sql psql -U postgres db_template < /vagrant/src/main/resources/db/postgresql/db_template.sql -# initialize the sqlfiddle central database, which has all sqlfiddle-specific data structures -createdb -U postgres -E UTF8 sqlfiddle -psql -U postgres sqlfiddle < /vagrant/src/main/resources/db/sqlfiddle/schema.sql -psql -U postgres sqlfiddle < /vagrant/src/main/resources/db/sqlfiddle/data.sql - -# initialize the openidm repository -psql -U postgres < /vagrant/src/main/resources/db/openidm/createuser.pgsql -psql -U openidm < /vagrant/src/main/resources/db/openidm/openidm.pgsql |