Vision/provision.sh at master · SnowBeaver/Vision · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
#!/bin/bash
cd /home/vision/www

git pull origin master
mkdir -p /home/vision/www/var/logs
chmod 0777 -R ./logs

# recreate database and load clean dump
echo "Stopping all services"
sudo service supervisor stop

# recreate database and load clean dump
echo "Installing database:"
sudo service postgresql restart

sudo -u postgres psql -c "ALTER USER postgres PASSWORD 'ViSiOn'";
PGPASSWORD="ViSiOn" psql -U postgres -p 5432 -h localhost -c "DROP DATABASE IF EXISTS vision";
PGPASSWORD="ViSiOn" psql -U postgres -p 5432 -h localhost -c "DROP ROLE IF EXISTS vision";
PGPASSWORD="ViSiOn" psql -U postgres -p 5432 -h localhost -c "CREATE ROLE vision WITH LOGIN PASSWORD 'ViSiOn'";
PGPASSWORD="ViSiOn" psql -U postgres -p 5432 -h localhost -c "ALTER ROLE vision WITH CREATEDB";
PGPASSWORD="ViSiOn" psql -U postgres -p 5432 -h localhost -c "CREATE DATABASE vision OWNER vision";


# complete provisioning using fabric on the host machine: fab setup_dev --password vagrant