dépôts
/
lhc
/
ateliers.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Ajout : etc/sv/sympa/ .
[lhc/ateliers.git]
/
etc
/
postgresql
/
bin
/
createuser
diff --git
a/etc/postgresql/bin/createuser
b/etc/postgresql/bin/createuser
index
16e5e04
..
56b37c9
100755
(executable)
--- a/
etc/postgresql/bin/createuser
+++ b/
etc/postgresql/bin/createuser
@@
-1,7
+1,7
@@
#!/bin/sh -eux
#!/bin/sh -eux
-
db
="$1"
-
owner="${2:-$db
}"
-sudo -u postgres psql "$
db
" -a -f - <<-EOF
+
user
="$1"
+
db="${2-
}"
+sudo -u postgres psql "$
{db-}
" -a -f - <<-EOF
\set ON_ERROR_STOP on
DO LANGUAGE plpgsql \$\$
BEGIN
\set ON_ERROR_STOP on
DO LANGUAGE plpgsql \$\$
BEGIN
@@
-21,5
+21,5
@@
sudo -u postgres psql "$db" -a -f - <<-EOF
END;
\$\$;
GRANT USAGE ON SCHEMA public TO $user;
END;
\$\$;
GRANT USAGE ON SCHEMA public TO $user;
- GRANT CONNECT,TEMPORARY ON DATABASE $db TO $user;
+ ${db:+GRANT CONNECT,TEMPORARY ON DATABASE $db TO $user;}
EOF
EOF