myheats

commit b13a366ef78a8485adad63a2363b87d1591564ca
parent bb4fbe0597b2d64bdeb47b65e9d7e9a46ef6f9e4
Author: Andreas Gruhler <andreas.gruhler@adfinis.com>
Date:   Sat, 28 Sep 2024 16:09:03 +0200

doc: postgres requirements for replication

Diffstat:
M
README.md
 | 
27
+++++++++++++++++++++++++++

1 file changed, 27 insertions(+), 0 deletions(-)
diff --git a/README.md b/README.md
@@ -59,6 +59,33 @@ Sign in process:
 * For sign in, the judge enters her email adress and receives a login link
 * The login information is stored in the browser session until sign out
 
+## Real-time replication
+The database user needs permissions to start `walsender`. Otherwise you
+encounter this error:
+```
+must be superuser or replication role to start walsender
+```
+
+To give the permissions:
+```sql
+ALTER USER myheats REPLICATION;
+\du
+```
+
+Also, the wal level needs to be set to `logical` in the postgresql config.
+Otherwise, this is the error message you will receive:
+```
+logical decoding requires wal_level >= logical
+```
+
+To set it in `postgresql.conf`:
+```
+# postgresql.conf
+wal_level = logical                     # minimal, replica, or logical
+```
+
+Restart database.
+
 ## Bulk import/export
 Use direct postgres database access:
 ```bash