Processes

Upgrading PostgreSQL

1. With new version of PostgreSQL running, delete all reinitialized users and databases
2. Stop the new version of PostgreSQL
3. Find old and new path for binaries (ls /nix/store/*postgresql-<version>*/bin/psql). Copy the /bin path (not the executable).
4. As postgres user, run pg_upgrade: pg_upgrade -b <old bin path> -B <new bin path> -d /var/lib/postgresql/<old version>/ -D /var/lib/postgresql/<new version>/
5. Restart PostgreSQL

Setting up a Cloudflare Tunnel

1. Create with Terraform
2. Output created token (ey...)
3. echo "token" | base64 --decode => {"a": "...", "t": "...", "s": "..."} => {"AccountTag":"","TunnelID":"","TunnelSecret":""} (this is the credentials file)