From dbf9b003ec473e1f4e65cfbe1ae0461c6f02c632 Mon Sep 17 00:00:00 2001 From: Julien Dessaux Date: Thu, 15 Apr 2021 14:54:06 +0200 Subject: Fixed postgresql part of the gitea installation notes --- content/docs/adyxax.org/git.md | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'content') diff --git a/content/docs/adyxax.org/git.md b/content/docs/adyxax.org/git.md index dc6edc9..3d8563b 100644 --- a/content/docs/adyxax.org/git.md +++ b/content/docs/adyxax.org/git.md @@ -15,11 +15,15 @@ pkg_add postgresql-server su - _postgresql mkdir /var/postgresql/data initdb -D /var/postgresql/data -U postgres -A scram-sha-256 -E UTF8 -W -exit +{{< /highlight >}} + +At this point you have to specify the postgres user password. Once done, exit the _postgresql users' shell and run as root : + +{{< highlight sh >}} rcctl enable postgresql rcctl start postgresql su - _postgresql -psql -U postgresql +psql -U postgres CREATE ROLE gitea WITH LOGIN PASSWORD 'XXXXX'; CREATE DATABASE gitea WITH OWNER gitea TEMPLATE template0 ENCODING UTF8 LC_COLLATE 'en_US.UTF-8' LC_CTYPE 'en_US.UTF-8'; {{< /highlight >}} -- cgit v1.2.3