diff options
| author | Karen Arutyunov <karen@codesynthesis.com> | 2023-12-29 15:32:45 +0300 |
|---|---|---|
| committer | Karen Arutyunov <karen@codesynthesis.com> | 2024-01-26 12:11:43 +0300 |
| commit | 6c1261465470f1487fba0f3439bbdf3ff2cea818 (patch) | |
| tree | af5cacda91deb2a773c5e21121d2aaec9df3a949 /etc | |
| parent | 7b3235be5c837f8ef74f099e5048251aeb17f093 (diff) | |
Adjust installation notes/script to comply with PostgreSQL 15 and above
Diffstat (limited to 'etc')
| -rwxr-xr-x | etc/private/install/brep-install | 9 |
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. |