blob: 6e75584b2df840e37c1d032339c360894e752942 (
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
32
|
echo "Setting up development database..."
lava_instance_user=devel
lava_password=devel
lava_database=devel
echo "Dropping old database and user"
sudo -u postgres dropdb $lava_database
sudo -u postgres dropuser $lava_instance_user
echo "Creating new user and database"
# Create database user
sudo -u postgres createuser \
--no-createdb \
--encrypted \
--login \
--no-superuser \
--no-createrole \
--no-password \
$lava_instance_user
# Set a password for our new user
sudo -u postgres psql \
--quiet \
--command="ALTER USER \"$lava_instance_user\" WITH PASSWORD '$lava_password'"
# Create a database for our new user
sudo -u postgres createdb \
--encoding=UTF-8 \
--owner=$lava_instance_user \
--no-password \
$lava_database
|