From 64e1dab38b26b32c1e53605a0788b7ad49d2af09 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Sun, 6 Apr 2014 11:50:10 +0200 Subject: Make it slightly easier to create a new SQL database, since we do not hard-code database names. --- sql/nms.sql | 36 ------------------------------------ 1 file changed, 36 deletions(-) (limited to 'sql/nms.sql') diff --git a/sql/nms.sql b/sql/nms.sql index 881e19a..bd695e1 100644 --- a/sql/nms.sql +++ b/sql/nms.sql @@ -1,39 +1,3 @@ --- --- 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 ''; -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 -- -- cgit v1.2.3