From: AJ ONeal <aj@therootcompany.com>
Date: Mon, 26 Oct 2020 08:29:34 +0000 (+0000)
Subject: add serviceman to postgres
X-Git-Url: https://git.josue.xyz/?p=webi-installers%2F.git;a=commitdiff_plain;h=861b305bf551b4f0759ba75c7d9bad38ec6f818d

add serviceman to postgres
---

diff --git a/postgres/README.md b/postgres/README.md
index 1c158eb..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
-
-```bash
-echo "postgres" > /tmp/pwfile
-mkdir -p $HOME/.local/share/postgres/var/
+### Start the postgres server
 
-initdb -D $HOME/.local/share/postgres/var/ \
-    --username postgres --pwfile "/tmp/pwfile" \
-    --auth-local=password --auth-host=password
+Run just once (for development):
 
-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/postgres/var -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/postgres/var -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
+```