From 9fe84bc1a2ef088e345e6215cf2e2fa3b53fc2da Mon Sep 17 00:00:00 2001
From: Alexis M <alexis@notmyidea.org>
Date: Mon, 7 Oct 2019 16:44:50 +0200
Subject: Enhance postgresql installation docs.

---
 docs/installation.rst | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

(limited to 'docs/installation.rst')

diff --git a/docs/installation.rst b/docs/installation.rst
index ab8fc57..5084a32 100644
--- a/docs/installation.rst
+++ b/docs/installation.rst
@@ -89,7 +89,14 @@ Configure database with PostgreSQL (optional)
 
     pip install psycopg2
 
-2. Configure :ref:`SQLALCHEMY_DATABASE_URI <configuration>` accordingly
+2. Create the users and tables. On the command line, this looks like::
+
+    sudo -u postgres psql
+    postgres=# create database mydb;
+    postgres=# create user myuser with encrypted password 'mypass';
+    postgres=# grant all privileges on database mydb to myuser;
+
+3. Configure :ref:`SQLALCHEMY_DATABASE_URI <configuration>` accordingly.
 
 
 Deploy it
-- 
cgit v1.1