docs: add database information

[awful.systems.git] / README.md

diff --git a/README.md b/README.md
index 768cead098ded08c2a8807390be562caf6a05721..8c1e2c4dc7269ac122ab11c2f60bae8e7ec67b0b 100644 (file)
--- a/README.md
+++ b/README.md
@@ -52,6 +52,11 @@ If you have `nix-direnv`, these commands will be available in your shell after
 it finishes a build. Otherwise, run `nix develop` to kick off a build, and the
 resulting shell will have all of these commands available.
 
+Deployment hosts are very thin and don't have a lot of commands available, so
+use `nix run nixpkgs#<command>` in an SSH session where `<command>` is the
+command you'd like to run in order to have Nix pull in and run a command line
+program.
+
 - `deploy-these`: Kick off a deployment to the host `these`. Any arguments are
   passed to `nixos-rebuild`.
 - `deploy-more`: Same as above for `more`.
@@ -63,3 +68,22 @@ resulting shell will have all of these commands available.
   in that file with the currently configured encryption keys. Will definitely
   need to be run by someone who previously has access to the secrets in order to
   succeed.
+
+## Services
+
+These can be administrated via `systemctl` and monitored via `journalctl` or
+your chosen log monitoring software.
+
+- `lemmy-prod`: The production Lemmy server.
+- `lemmy-ui-prod`: The Web frontend to the production Lemmy server.
+- `lemmy-dev`: The development Lemmy server.
+- `lemmy-ui-dev`: The Web frontend to the development Lemmy server.
+
+## Databases
+
+- For development, the database user is `lemmy_dev` and the Postgres database is
+  `lemmy_dev` on `these.awful.systems`. Use `sudo -u lemmy_dev psql` on that
+  host to access the database. 
+- For production, the database user is `lemmy` and the Postgres database is
+  `lemmy` on `more.awful.systems`. Use `sudo -u lemmy_dev psql` on that host to
+  access the database.