diff options
Diffstat (limited to 'sql/nms.sql')
-rw-r--r-- | sql/nms.sql | 36 |
1 files changed, 0 insertions, 36 deletions
diff --git a/sql/nms.sql b/sql/nms.sql index 881e19a..bd695e1 100644 --- a/sql/nms.sql +++ b/sql/nms.sql @@ -1,40 +1,4 @@ -- --- PostgreSQL database cluster dump --- - -\connect postgres - -SET client_encoding = 'UTF8'; -SET standard_conforming_strings = on; - --- --- Roles --- - -CREATE ROLE nms; -ALTER ROLE nms WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION PASSWORD '<removed>'; -CREATE ROLE postgres; -ALTER ROLE postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION; - - - - - - --- --- Database creation --- - -CREATE DATABASE nms WITH TEMPLATE = template0 OWNER = nms; -REVOKE ALL ON DATABASE template1 FROM PUBLIC; -REVOKE ALL ON DATABASE template1 FROM postgres; -GRANT ALL ON DATABASE template1 TO postgres; -GRANT CONNECT ON DATABASE template1 TO PUBLIC; - - -\connect nms - --- -- PostgreSQL database dump -- |