I did some more rooting around. First, postgresql 9.0.5 was dying because the database files were initialized with postgresql 8.3.4. Then I deleted /var/db/postgresql, killed the "hung" pre-start init process and did a "start postgresql". Now the server is dying because it cannot load pg_hba.conf (so it says). I've gone through by hand and "tailed" it as the postgres user without problem (see below). So: not a bad link, not a permissions problem...Any ideas what's going wrong? Aside from specifying that I want to install postgresql 9.0.5, I haven't customized it at all...
/var/log/warn : Feb 3 22:51:51 storage postgres[4029]: [3-1] FATAL: could not load pg_hba.conf ...(no other relevant messages in any log file)... [root@storage:/var/db]# sudo -u postgres tail /var/db/postgresql/postgresql.conf hba_file = '/nix/store/3avdnkfi1lcnn1cnk0fykam9xdmszmmn-pg_hba.conf' ident_file = '/nix/store/vijm0680br39bwic17m6m1wb0lcm8vk7-pg_ident.conf' log_destination = 'syslog' [root@storage:/var/db]# sudo -u postgres tail /nix/store/3avdnkfi1lcnn1cnk0fykam9xdmszmmn-pg_hba.conf # 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 2012/2/3 Lluís Batlle i Rossell <[email protected]> > Maybe it was built already, because it was a dependency of something in > your > previous builds. Check /etc/init.d/postgresql.conf, and see what it points > to. > I believe you're right, now that you mention it. But I cannot confirm via /etc/init.d/* as that directory does not appear to exist. I have an /etc/init/postgresql.conf, but this points to an "upstart" thing, and not something I can trace back to a particular version of postgresql: [root@storage:/var/db]# ls -l /etc/init/postgresql.conf lrwxrwxrwx 1 root root 32 Feb 3 22:35 /etc/init/postgresql.conf -> /etc/static/init/postgresql.conf [root@storage:/var/db]# ls -l /etc/static/init/postgresql.conf lrwxrwxrwx 1 root nixbld 67 Feb 3 22:24 /etc/static/init/postgresql.conf -> /nix/store/4fj3cxqxawyyzggm3r6indf44fp8ypg7-upstart-postgresql.conf [root@storage:/var/db]# ls -l /nix/store/4fj3cxqxawyyzggm3r6indf44fp8ypg7-upstart-postgresql.conf -r--r--r-- 1 root nixbld 2477 Jan 1 1970 /nix/store/4fj3cxqxawyyzggm3r6indf44fp8ypg7-upstart-postgresql.conf [root@storage:/var/db]# tail /nix/store/4fj3cxqxawyyzggm3r6indf44fp8ypg7-upstart-postgresql.conf exec >> /var/log/upstart/postgresql 2>&1 /nix/store/xpr8jhr113cz32r4c5zkqrm51y1wx4sz-shadow-4.1.4.2/bin/su -s /nix/store/j8rrk6dkrcaa8r1j5987g94154rkawy9-bash-4.1-p2/bin/bash postgres -c '/nix/store/lr40r8rgvnf18zbfpwz9r6i02q3p1ghy-postgresql-9.0.5/bin/pg_ctl stop -m fast' end script ... Arie wrote: > nixpkgs.config = { > packageOverrides = orig: { > postgresql = pkgs.postgresql90; > }; > }; Yup, that's exactly what I was looking for! Thanks!! Bryce
_______________________________________________ nix-dev mailing list [email protected] http://lists.science.uu.nl/mailman/listinfo/nix-dev
