Talk:PostgreSQL
Latest comment: 1 February by Technius in topic Best place to discuss backups
The instructions are incomplete and lead to a systm that never runs because is missing the local part. This is what worked for me.
services.postgresql = {
settings = {
listen_addresses = "*";
};
enable = true;
enableTCPIP = true;
authentication = pkgs.lib.mkOverride 10 ''
local all all trust
host all all ::1/128 trust
host all postgres 127.0.0.1/32 trust
'';
};
if you just do the part that accepts TCP connections WITHOUT the local, it just doesn't run because it is missing it.
Best place to discuss backups
Is this page an appropriate place to mention using a program like <code>pgbackrest</code> to perform backups, or would a separate page be better? Technius (talk) 20:30, 1 February 2026 (UTC)