diff options
| author | tom barrett <spalf0@gmail.com> | 2019-03-25 07:02:41 -0500 |
|---|---|---|
| committer | tom barrett <spalf0@gmail.com> | 2019-03-26 03:42:37 -0500 |
| commit | ca5ee0b32b616fb8fa5e7e44c74acecefab719c3 (patch) | |
| tree | 21c7e7bf840e0f7e52290245d9f7c9e12cafde2d /postgres/bootstrap.sh | |
| parent | d6ec0850b896918faf83f0eab325ec8c1f89e2bb (diff) | |
added pgadmin
Diffstat (limited to 'postgres/bootstrap.sh')
| -rw-r--r-- | postgres/bootstrap.sh | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/postgres/bootstrap.sh b/postgres/bootstrap.sh index 03f7eef..391aeab 100644 --- a/postgres/bootstrap.sh +++ b/postgres/bootstrap.sh @@ -7,7 +7,7 @@ apt-get upgrade -y apt-get install -y xauth # deps -apt-get install -y postgresql postgresql-client +apt-get install -y postgresql postgresql-client pgadmin3 # set up db sudo -u postgres psql -c "CREATE USER space WITH PASSWORD 'space';" @@ -15,6 +15,10 @@ sudo -u postgres psql -c "CREATE DATABASE space_db WITH OWNER space;" # copy configs cp /vagrant/postgres/*conf /etc/postgresql/9.6/main/ +cp /vagrant/postgres/.pg* /home/vagrant/ + +# give ownership +chown -R vagrant:vagrant /home/vagrant # systemd systemctl restart postgresql |