summaryrefslogtreecommitdiffstats
path: root/server/db-init.sh
blob: c9150e9de5d9dd207a6ee3a409f774f25f8d86f8 (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
33
34
35
36
37
38
39
40
41
42
43
#!/bin/bash

username=lemmy
dbname=lemmy
port=5432

password=""
password_confirm=""
password_valid=0

while [ "$password_valid" == 0 ]
do
  read -p "Enter database password: " -s password
  echo

  read -p "Verify database password: " -s password_confirm
  echo
  echo

  # Start the loop from the top if either check fails
  if [ -z "$password" ]
  then
    echo "Error: Password cannot be empty." 1>&2
    echo
    continue
  fi
  if [ "$password" != "$password_confirm" ]
  then
    echo "Error: Passwords don't match." 1>&2
    echo
    continue
  fi

  # Set the password_valid variable to break out of the loop
  password_valid=1
done


psql -c "CREATE USER $username WITH PASSWORD '$password' SUPERUSER;" -U postgres
psql -c 'CREATE DATABASE $dbname WITH OWNER $username;' -U postgres
export LEMMY_DATABASE_URL=postgres://$username:$password@localhost:$port/$dbname

echo $LEMMY_DATABASE_URL