[Nix-dev] Bug in postgresql service + postgresql 9.0.6 patch

Bryce L Nordgren bnordgren at gmail.com
Wed Feb 8 00:29:09 CET 2012


Attached, pls find the patch for latest version in postgresql 9.0.x series.

I found out why my postgresql84 and postgresql90 services were crashing.
The default value for services.postgresql.authentication is mal-formed for
these two versions. Apparently, it works fine for postgresql83.

The last parameter on the "local" authentication lines is mal-formed.
Postgresql is expecting "parameter=value". I'm not a real expert in this,
so I just got rid of the last field entirely. The only thing I could find
in the postgresql manual concerning this field with a cursory search is
"map=mapname":

      authentication = mkOption {
        default = ''
          # Generated file; do not edit!
          local all mediawiki        ident mediawiki-users
          local all all              ident sameuser
          host  all all 127.0.0.1/32 md5
          host  all all ::1/128      md5
        '';
        description = ''
          Defines how users authenticate themselves to the server.
        '';
      };

Postgresql is starting now, with this addition to my configuration.nix:

  services.postgresql = {
    enable = true ;
    enableTCPIP = true ;
    authentication = ''
     # generated file, do not edit!
     local all all trust
     host  all all 127.0.0.1/32 md5
     host  all all 0.0.0.0/0    md5
    '';
  } ;

Yes, I intentionally trusted my own machine.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.science.uu.nl/pipermail/nix-dev/attachments/20120207/9ed9384b/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 9.0.x.patch
Type: text/x-patch
Size: 694 bytes
Desc: not available
Url : http://lists.science.uu.nl/pipermail/nix-dev/attachments/20120207/9ed9384b/attachment.bin 


More information about the nix-dev mailing list