aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJulien Dessaux2021-06-10 10:59:54 +0200
committerJulien Dessaux2021-06-10 11:52:49 +0200
commit265055be172d6f71e086908fc1123b62840db0f2 (patch)
treea24c2432f93b4728e8fa35f685620813247a479d
parentFixed footer aspect (diff)
downloadwww-265055be172d6f71e086908fc1123b62840db0f2.tar.gz
www-265055be172d6f71e086908fc1123b62840db0f2.tar.bz2
www-265055be172d6f71e086908fc1123b62840db0f2.zip
Reworked article
Diffstat (limited to '')
-rw-r--r--content/docs/freebsd/postgresql.md5
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