blob: 11474a9158110c20d34fb71cbd4deac08b26146a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
#!/bin/bash
# prepare deps
export DEBIAN_FRONTEND=noninteractive
apt-get update
apt-get upgrade -y
apt-get install -y xauth
# deps
apt-get install -y postgresql postgresql-client pgadmin3
# set up db
USERNAME=$(grep POSTGRES_USERNAME /vagrant/src/constants.rs | cut -d '"' -f2)
PASSWORD=$(grep POSTGRES_PASSWORD /vagrant/src/constants.rs | cut -d '"' -f2)
DB_NAME=$(grep POSTGRES_DB_NAME /vagrant/src/constants.rs | cut -d '"' -f2)
sudo -u postgres psql -c "CREATE USER $USERNAME WITH PASSWORD '$PASSWORD';"
sudo -u postgres psql -c "CREATE DATABASE $DB_NAME WITH OWNER $USERNAME;"
# copy configs
cp /vagrant/postgres/pg_hba.conf /etc/postgresql/9.6/main/
cp /vagrant/postgres/postgresql.conf /etc/postgresql/9.6/main/
cp /vagrant/postgres/.pgadmin3 /home/vagrant/
echo "localhost:5432:*:$USERNAME:$PASSWORD" > /home/vagrant/.pgpass
# give permissions
chmod 0600 /home/vagrant/.pgpass
chown -R vagrant:vagrant /home/vagrant
# systemd
systemctl restart postgresql
|
