X-Git-Url: https://git.cyclocoop.org/?a=blobdiff_plain;f=etc%2Fpostgresql%2Fbin%2Fcreateuser;fp=etc%2Fpostgresql%2Fbin%2Fcreateuser;h=0000000000000000000000000000000000000000;hb=3ad6118386977e346d81042e924e5db9c5f15b7d;hp=56b37c9e875b88587d4226d21fca026863902bdb;hpb=22f04b9fac14adc3d3fc98273ba126c3a51792c3;p=lhc%2Fateliers.git diff --git a/etc/postgresql/bin/createuser b/etc/postgresql/bin/createuser deleted file mode 100755 index 56b37c9..0000000 --- a/etc/postgresql/bin/createuser +++ /dev/null @@ -1,25 +0,0 @@ -#!/bin/sh -eux -user="$1" -db="${2-}" -sudo -u postgres psql "${db-}" -a -f - <<-EOF - \set ON_ERROR_STOP on - DO LANGUAGE plpgsql \$\$ - BEGIN - IF NOT EXISTS ( - SELECT * - FROM pg_catalog.pg_user - WHERE usename = '$user' - LIMIT 1 - ) THEN - CREATE ROLE $user - LOGIN - NOCREATEDB - NOCREATEROLE - NOINHERIT - NOSUPERUSER; - END IF; - END; - \$\$; - GRANT USAGE ON SCHEMA public TO $user; - ${db:+GRANT CONNECT,TEMPORARY ON DATABASE $db TO $user;} - EOF