aboutsummaryrefslogtreecommitdiff
path: root/INSTALL-DEV
diff options
context:
space:
mode:
Diffstat (limited to 'INSTALL-DEV')
-rw-r--r--INSTALL-DEV17
1 files changed, 14 insertions, 3 deletions
diff --git a/INSTALL-DEV b/INSTALL-DEV
index 101d9d7..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
@@ -72,7 +83,7 @@ CREATE EXTENSION postgres_fdw;
CREATE SERVER package_server
FOREIGN DATA WRAPPER postgres_fdw
- OPTIONS (dbname 'brep_package', updatable 'false');
+ OPTIONS (dbname 'brep_package', updatable 'true');
GRANT USAGE ON FOREIGN SERVER package_server to <user>;
@@ -113,7 +124,7 @@ CREATE EXTENSION citext;
Exit psql (^D)
-2. Create Database Schemes and Load the Repository
+2. Create Database Schemas and Load the Repository
All the commands are executed from brep project root.
@@ -205,7 +216,7 @@ $ sudo tail -f /var/log/apache2/error.log
4. Reloading During Development
-To do a "complete reload" (i.e., recreate database schemes, load the repository
+To do a "complete reload" (i.e., recreate database schemas, load the repository
data, and reload the Apache2 plugin), execute the following from brep/:
$ migrate/brep-migrate --recreate package