Ajout : DAViCal + CalDavZAP + AgenDAV .

[lhc/ateliers.git] / local / postgresql-role-create

diff --git a/local/postgresql-role-create b/local/postgresql-role-create
new file mode 100755 (executable)
index 0000000..e01f0c4
--- /dev/null
+++ b/local/postgresql-role-create
@@ -0,0 +1,22 @@
+#!/bin/sh -eux
+role="$1"; shift
+sudo -u postgres psql "$@" -a -f - <<-EOF
+       \set ON_ERROR_STOP on
+       DO LANGUAGE plpgsql \$\$
+       BEGIN
+               IF NOT EXISTS (
+                SELECT *
+                FROM pg_catalog.pg_roles
+                WHERE rolname = '$role'
+                LIMIT 1
+               ) THEN
+                       CREATE ROLE $role
+                        NOLOGIN
+                        NOCREATEDB
+                        NOCREATEROLE
+                        NOINHERIT
+                        NOSUPERUSER;
+               END IF;
+       END;
+       \$\$;
+       EOF