diff options
| author | jakefeasel <jfeasel@gmail.com> | 2015-05-11 09:51:55 -0700 |
|---|---|---|
| committer | jakefeasel <jfeasel@gmail.com> | 2015-05-11 09:51:55 -0700 |
| commit | 810c359cf2ef1c0351d64329526ebedccb42d1df (patch) | |
| tree | fd2bbb3b9848289219043e07ac645ae888fbef6d /vagrant_scripts/pgpool_bootstrap.sh | |
| parent | 774593181c9ee7c2c3ef3f0d20a1500407d782a6 (diff) | |
| download | sqlfiddle2-810c359cf2ef1c0351d64329526ebedccb42d1df.zip sqlfiddle2-810c359cf2ef1c0351d64329526ebedccb42d1df.tar.gz sqlfiddle2-810c359cf2ef1c0351d64329526ebedccb42d1df.tar.bz2 | |
Initial support for a pgpool-based database cluster for openidm repo and sqlfiddle central databases. Moving fiddle env for pg93 into separate vm
Diffstat (limited to 'vagrant_scripts/pgpool_bootstrap.sh')
| -rwxr-xr-x | vagrant_scripts/pgpool_bootstrap.sh | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/vagrant_scripts/pgpool_bootstrap.sh b/vagrant_scripts/pgpool_bootstrap.sh new file mode 100755 index 0000000..0d44376 --- /dev/null +++ b/vagrant_scripts/pgpool_bootstrap.sh @@ -0,0 +1,22 @@ + +echo "10.0.0.16 APPDB1" >> /etc/hosts +echo "10.0.0.26 APPDB2" >> /etc/hosts + + +apt-get --yes update +apt-get --yes upgrade +apt-get --yes --force-yes install pgpool2=3.3.2-1ubuntu1 libpgpool0=3.3.2-1ubuntu1 + +cp /vagrant/src/main/resources/db/sqlfiddle/pgpool.conf /etc/pgpool2/pgpool.conf + + +echo postgres:`pg_md5 password` >> /etc/pgpool2/pcp.conf +echo "host all all 10.0.0.14/32 trust" >> /etc/pgpool2/pool_hba.conf +echo "host all all 10.0.0.24/32 trust" >> /etc/pgpool2/pool_hba.conf + +mkdir /APPDB1_data +mkdir /APPDB2_data + +chown postgres /APPDB*_data + +service pgpool2 restart
\ No newline at end of file |