[Nix-dev] Selecting a version of postgresql

[Bryce L Nordgren]

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 at 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 at 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 <viric at viric.name>

> 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 at 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 at 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 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.science.uu.nl/pipermail/nix-dev/attachments/20120203/74c89221/attachment.html