Skip to main content
summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
Diffstat (limited to 'openk-platform/config/setup-database/setup-postgeSQL.sql')
-rw-r--r--openk-platform/config/setup-database/setup-postgeSQL.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/openk-platform/config/setup-database/setup-postgeSQL.sql b/openk-platform/config/setup-database/setup-postgeSQL.sql
index 07eb496f..12cf11f8 100644
--- a/openk-platform/config/setup-database/setup-postgeSQL.sql
+++ b/openk-platform/config/setup-database/setup-postgeSQL.sql
@@ -7,6 +7,7 @@
--
-- Liferay Portal Database
+-- Connect as postgres (master) user
CREATE ROLE lportalopenk LOGIN PASSWORD 'lportalopenk' VALID UNTIL 'infinity'
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
CREATE DATABASE openk
@@ -18,6 +19,7 @@ CREATE DATABASE openk
CREATE SCHEMA lportalopenk AUTHORIZATION lportalopenk;
-- CacheDB Database
+-- Connect as postgres (master) user
CREATE ROLE cachedb LOGIN PASSWORD 'cachedb' VALID UNTIL 'infinity'
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
CREATE DATABASE cachedb
@@ -29,6 +31,7 @@ CREATE DATABASE cachedb
CREATE SCHEMA cachedb AUTHORIZATION cachedb;
-- AppDB Database
+-- Connect as postgres (master) user
CREATE ROLE eisman LOGIN PASSWORD 'eisman' VALID UNTIL 'infinity'
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
--CREATE ROLE netstate LOGIN PASSWORD 'netstate' VALID UNTIL 'infinity'

Back to the top