aboutsummaryrefslogtreecommitdiff
path: root/INSTALL-DEV
diff options
context:
space:
mode:
authorKaren Arutyunov <karen@codesynthesis.com>2023-12-29 15:32:45 +0300
committerKaren Arutyunov <karen@codesynthesis.com>2024-01-26 12:11:43 +0300
commit6c1261465470f1487fba0f3439bbdf3ff2cea818 (patch)
treeaf5cacda91deb2a773c5e21121d2aaec9df3a949 /INSTALL-DEV
parent7b3235be5c837f8ef74f099e5048251aeb17f093 (diff)
Adjust installation notes/script to comply with PostgreSQL 15 and above
Diffstat (limited to 'INSTALL-DEV')
-rw-r--r--INSTALL-DEV11
1 files changed, 11 insertions, 0 deletions
diff --git a/INSTALL-DEV b/INSTALL-DEV
index ee9f980..8ebc5a3 100644
--- a/INSTALL-DEV
+++ b/INSTALL-DEV
@@ -55,6 +55,17 @@ CREATE USER "www-data" INHERIT IN ROLE <user>;
CREATE USER "brep-build" INHERIT IN ROLE <user> PASSWORD '-';
+Note that starting with PostgreSQL 15 only the database owner can create the
+objects in the public schema by default. Thus, if the PostgreSQL version is 15
+or above, then all the privileges on this schema in the created databases need
+to be granted explicitly by the postgres user to <user>:
+
+\c brep_package
+GRANT ALL PRIVILEGES ON SCHEMA public TO <user>;
+
+\c brep_build
+GRANT ALL PRIVILEGES ON SCHEMA public TO <user>;
+
Exit psql (^D), then make sure the logins work:
$ psql -d brep_package