1  #!/bin/bash
 2  
 3  # sudo su postgres
 4  
 5  # postgresql://$USER:$PW@localhost/$DB
 6  
 7  PW="C8kdcUrAQy66U"
 8  DB="gargandb1"
 9  USER="gargantua"
10  
11  #psql -c "CREATE USER \"${USER}\""
12  #psql -c "ALTER USER \"${USER}\" with PASSWORD '${PW}'"
13  
14  psql -c "DROP DATABASE IF EXISTS \"${DB}\""
15  createdb "${DB}"
16  psql -c "ALTER DATABASE \"${DB}\" OWNER to \"${USER}\""
17  
18  
19  
20  
21