X-Git-Url: https://git.josue.xyz/?a=blobdiff_plain;f=postgres%2FREADME.md;h=8c6a83c987c82b72ee7a5366e518322ab8c396cb;hb=29d0b6075ede95931cae301d7050d60309e08ff7;hp=69cae3b2d30b976261634bec035a32422144fbb5;hpb=c77b2afba8be0e2aca21ad2647e7e847e4a8aa14;p=webi-installers%2F.git

diff --git a/postgres/README.md b/postgres/README.md
index 69cae3b..8c6a83c 100644
--- a/postgres/README.md
+++ b/postgres/README.md
@@ -19,23 +19,20 @@ Use `@x.y.z` for a specific version.
 > handles SQL, 'NoSQL', JSON, HSTORE, Full-Text Search, Messages Queues and
 > more. Best bang for buck.
 
-### Initialize a database with a password
+### Start the postgres server
 
-```bash
-echo "postgres" > /tmp/pwfile
-mkdir -p $HOME/.local/share/postgres/var/
+Run just once (for development):
 
-initdb -D $HOME/.local/share/postgres/var/ \
-    --username postgres --pwfile "/tmp/pwfile" \
-    --auth-local=password --auth-host=password
-
-rm /tmp/pwfile
+```bash
+postgres -D $HOME/.local/share/postgres/var -p 5432
 ```
 
-### Start the postgres server
+Run as a system service on Linux:
 
 ```bash
-postgres -D $HOME/.local/share/var/postgres -p 5432
+sudo env PATH="$PATH" \
+    serviceman add --system --username $(whoami) --name postgres -- \
+    postgres -D "$HOME/.local/share/postgres/var" -p 5432
 ```
 
 ### Connect with the psql client
@@ -43,3 +40,16 @@ postgres -D $HOME/.local/share/var/postgres -p 5432
 ```bash
 psql 'postgres://postgres:postgres@localhost:5432/postgres'
 ```
+
+### Initialize a database with a password
+
+```bash
+echo "postgres" > /tmp/pwfile
+mkdir -p $HOME/.local/share/postgres/var/
+
+initdb -D $HOME/.local/share/postgres/var/ \
+    --username postgres --pwfile "/tmp/pwfile" \
+    --auth-local=password --auth-host=password
+
+rm /tmp/pwfile
+```