aboutsummaryrefslogtreecommitdiff
path: root/etc/private
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 /etc/private
parent7b3235be5c837f8ef74f099e5048251aeb17f093 (diff)
Adjust installation notes/script to comply with PostgreSQL 15 and above
Diffstat (limited to 'etc/private')
-rwxr-xr-xetc/private/install/brep-install9
1 files changed, 9 insertions, 0 deletions
diff --git a/etc/private/install/brep-install b/etc/private/install/brep-install
index 29c3310..37179c2 100755
--- a/etc/private/install/brep-install
+++ b/etc/private/install/brep-install
@@ -271,6 +271,12 @@ GRANT ALL PRIVILEGES ON DATABASE brep_package, brep_build TO brep;
CREATE USER "www-data" INHERIT IN ROLE brep;
CREATE USER "brep-build" INHERIT IN ROLE brep PASSWORD '-';
+
+\c brep_package
+GRANT ALL PRIVILEGES ON SCHEMA public TO brep;
+
+\c brep_build
+GRANT ALL PRIVILEGES ON SCHEMA public TO brep;
EOF
# Create the "staging" package database for the submit-pub package submission
@@ -284,6 +290,9 @@ LC_COLLATE 'en_US.UTF8'
LC_CTYPE 'en_US.UTF8';
GRANT ALL PRIVILEGES ON DATABASE brep_submit_package TO brep;
+
+\c brep_submit_package
+GRANT ALL PRIVILEGES ON SCHEMA public TO brep;
EOF
# Make sure the 'brep' and Apache2 user's logins work properly.