diff options
| author | Franck Cuny <franck@fcuny.net> | 2026-01-23 08:49:30 -0800 |
|---|---|---|
| committer | Franck Cuny <franck@fcuny.net> | 2026-01-23 08:49:30 -0800 |
| commit | c78f92b2e9313f75bb29abb919171979393ec0c8 (patch) | |
| tree | c90c010f36cf28697fac3bcca49e9f6c591302f4 /README.org | |
| parent | simplify secrets management with dynamic public key generation (diff) | |
| download | infra-c78f92b2e9313f75bb29abb919171979393ec0c8.tar.gz | |
enable postgresql + backups
Diffstat (limited to 'README.org')
| -rw-r--r-- | README.org | 11 |
1 files changed, 10 insertions, 1 deletions
@@ -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 |
