[incubator-age-website] branch master updated: Add instructions to allow non-superusers to use Apache AGE (#25)

[jo...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

joshinnis pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-age-website.git


The following commit(s) were added to refs/heads/master by this push:
     new 83ede03  Add instructions to allow non-superusers to use Apache AGE (#25)
83ede03 is described below

commit 83ede037d89431e11103e3e345d17a58b085edea
Author: Pieterjan De Potter <pi...@ugent.be>
AuthorDate: Mon Jan 17 07:36:26 2022 +0100

    Add instructions to allow non-superusers to use Apache AGE (#25)
---
 docs/intro/setup.md | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

diff --git a/docs/intro/setup.md b/docs/intro/setup.md
index bf12b26..9daf32a 100644
--- a/docs/intro/setup.md
+++ b/docs/intro/setup.md
@@ -68,3 +68,17 @@ We recommend adding ag_catalog to your search_path to simplify your queries. The
 ```postgresql
 SET search_path = ag_catalog, "$user", public;
 ```
+
+### Optional: allow non-superusers to use Apache AGE
+
+* Non-superusers can only apply LOAD to library files located in `$libdir/plugins/` (see <https://www.postgresql.org/docs/11/sql-load.html>). A symlink can be created to allow non-superusers to LOAD the Apache AGE library:
+
+```console
+sudo ln -s /usr/lib/postgresql/11/lib/age.so /usr/lib/postgresql/11/lib/plugins/age.so
+```
+
+* In order to use Apache AGE, users need `USAGE` privileges on the `ag_catalog` schema (example for user `db_user`):
+
+```postgresql
+GRANT USAGE ON SCHEMA ag_catalog TO db_user;
+```