diff options
| author | Julien Dessaux | 2021-06-10 10:59:54 +0200 |
|---|---|---|
| committer | Julien Dessaux | 2021-06-10 11:52:49 +0200 |
| commit | 265055be172d6f71e086908fc1123b62840db0f2 (patch) | |
| tree | a24c2432f93b4728e8fa35f685620813247a479d | |
| parent | Fixed footer aspect (diff) | |
| download | www-265055be172d6f71e086908fc1123b62840db0f2.tar.gz www-265055be172d6f71e086908fc1123b62840db0f2.tar.bz2 www-265055be172d6f71e086908fc1123b62840db0f2.zip | |
Reworked article
Diffstat (limited to '')
| -rw-r--r-- | content/docs/freebsd/postgresql.md | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/content/docs/freebsd/postgresql.md b/content/docs/freebsd/postgresql.md index 9fac8c7..c2797c2 100644 --- a/content/docs/freebsd/postgresql.md +++ b/content/docs/freebsd/postgresql.md @@ -56,9 +56,8 @@ bastille service postgresql postgresql start Let's say we want to allow a gitea jail running from 10.0.0.4 to a gitea database using a gitea user : ``` -echo "CREATE ROLE gitea WITH LOGIN PASSWORD 'secret';" \ - | bastille cmd postgresql su - postgres -c psql -echo "CREATE DATABASE gitea WITH OWNER gitea TEMPLATE template0 ENCODING UTF8 LC_COLLATE 'en_US.UTF-8' LC_CTYPE 'en_US.UTF-8';" \ +echo "CREATE ROLE gitea WITH LOGIN PASSWORD 'secret'; + CREATE DATABASE gitea WITH OWNER gitea TEMPLATE template0 ENCODING UTF8 LC_COLLATE 'en_US.UTF-8' LC_CTYPE 'en_US.UTF-8';" \ | bastille cmd postgresql su - postgres -c psql echo "host gitea gitea 10.0.0.4/32 scram-sha-256" | bastille cmd postgresql tee -a /var/db/postgres/data13/pg_hba.conf |