#!/bin/sh -eux
role="$1"; shift
sudo -u postgres psql "$@" -a -f - --set ON_ERROR_STOP=1 <<-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