sourcephile
/
git
/
gargantext.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
work in progress
[gargantext.git]
/
devops
/
postgres
/
create
1
#!/bin/bash
2
3
sudo su postgres
4
5
PW
=
"password"
6
DB
=
"gargandbV5"
7
USER
=
"gargantua"
8
9
psql
-c
"CREATE USER
\"
${USER}
\"
10
psql -c "
ALTER USER
\"
${USER}
\"
with PASSWORD
\"
${PW}
\"
"
11
12
psql -c "
DROP DATABASE IF EXISTS
\"
${DB}
\"
"
13
createdb "
${DB}
"
14
psql "
${DB}
" < schema.sql
15
16
psql -c "
ALTER DATABASE
\"
${DB}
\"
OWNER to
\"
${USER}
\"
;
"
17
18
19
20
21