Talk:PostgreSQL

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)