summaryrefslogtreecommitdiff
path: root/postgres/bootstrap.sh
blob: 03f7eef6654293fdd99d36990d59e080ea8de0f2 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
#!/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

# set up db
sudo -u postgres psql -c "CREATE USER space WITH PASSWORD 'space';"
sudo -u postgres psql -c "CREATE DATABASE space_db WITH OWNER space;"

# copy configs
cp /vagrant/postgres/*conf /etc/postgresql/9.6/main/

# systemd
systemctl restart postgresql