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

diff --git a/postgres/README.md b/postgres/README.md
index 69cae3b..453237c 100644
--- a/postgres/README.md
+++ b/postgres/README.md
@@ -5,13 +5,8 @@ tagline: |
   PostgreSQL: The World's Most Advanced Open Source Relational Database.
 ---
 
-## Updating `postgres`
-
-```bash
-webi postgres@stable
-```
-
-Use `@x.y.z` for a specific version.
+To update or switch versions, run `webi postgres@stable` (or `@v10`, `@beta`,
+etc).
 
 ## Cheat Sheet
 
@@ -19,23 +14,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/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 +35,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
+```