X-Git-Url: http://git.cyclocoop.org/?a=blobdiff_plain;ds=sidebyside;f=etc%2Fpostgresql%2Fbin%2Fcreateuser;h=56b37c9e875b88587d4226d21fca026863902bdb;hb=b27661cf8e40872543f86a00922d18573ef83612;hp=16e5e04e82053159413c78b7fc4bec2ca4167dc7;hpb=7c02698fa11a13fd332c2e95986339241aaa79a6;p=lhc%2Fateliers.git diff --git a/etc/postgresql/bin/createuser b/etc/postgresql/bin/createuser index 16e5e04..56b37c9 100755 --- a/etc/postgresql/bin/createuser +++ b/etc/postgresql/bin/createuser @@ -1,7 +1,7 @@ #!/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 @@ -21,5 +21,5 @@ sudo -u postgres psql "$db" -a -f - <<-EOF 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