From 6c1261465470f1487fba0f3439bbdf3ff2cea818 Mon Sep 17 00:00:00 2001 From: Karen Arutyunov Date: Fri, 29 Dec 2023 15:32:45 +0300 Subject: Adjust installation notes/script to comply with PostgreSQL 15 and above --- INSTALL | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'INSTALL') diff --git a/INSTALL b/INSTALL index ebcf851..79d698f 100644 --- a/INSTALL +++ b/INSTALL @@ -171,6 +171,17 @@ CREATE USER MAPPING FOR PUBLIC SERVER package_server OPTIONS (user 'brep-build', 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 the brep user: + +\c brep_package +GRANT ALL PRIVILEGES ON SCHEMA public TO brep; + +\c brep_build +GRANT ALL PRIVILEGES ON SCHEMA public TO brep; + Exit psql (^D) The user brep-build is required (by the postgres_fdw extension) to login with -- cgit v1.1