From c78f92b2e9313f75bb29abb919171979393ec0c8 Mon Sep 17 00:00:00 2001 From: Franck Cuny Date: Fri, 23 Jan 2026 08:49:30 -0800 Subject: enable postgresql + backups --- README.org | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'README.org') diff --git a/README.org b/README.org index d36768a..0a06f13 100644 --- a/README.org +++ b/README.org @@ -126,6 +126,15 @@ Backups are done with =restic= and are stored on the local machine, and they are ** Remote builders *** Clients On the clients, you can run =nix config show builders= to see the list of the remote builders. -If a client is failing to run builds remotely due to some ssh errors, you can run the following command: =sudo ssh -o 'IdentityAgent none' -i PRIVATE_KEY USER@HOST true=. We need to use =sudo= since the nix daemon runs as root. +If a client is failing to run builds remotely due to some ssh errors, you can run the following command: =sudo ssh -o 'IdentityAgent none' -i /run/agenix/ssh-remote-builder builder@builder true=. We need to use =sudo= since the nix daemon runs as root. *** Builders On the builders, you can run =nix config show allowed-users= to see the list of users who can trigger nix builds. +** PostgreSQL +To connect from my local machine remotely: +#+begin_src shell +ssh framebox -L 35432:/var/run/postgresql/.s.PGSQL.5432 +#+end_src +Then: +#+begin_src shell +psql -U postgres -h localhost -p 35432 +#+end_src -- cgit v1.2.3