Re: Gentoo, 8,2 ---> 8.4, and /var/run/postgresql in mode 770

On Sat, Jan 9, 2010 at 2:20 PM, <felix(at)crowfix(dot)com> wrote:
> I just upgraded my home gentoo system's postgresql from 8.2.14 to
> 8.4.2.  I use it mostly for fooling around and keeping smatterings of
> personal data, so it was simple laziness which kept me from upgrading
> sooner, triggered by the gentoo switch back in 8.2.mumble in how they
> manage postgresql.
>
> Everything went smoothly except the permissions of the directory
> /var/run/postgresql with the domain socket .s.PGSQL.5432.  This dir
> had permissions of 770, owned by postgres.postgres, so no mere mortals
> could access it.  I have changed this to 775 and can now access it.
>
> Didn't 8.2 put these in /tmp?  Maybe this was a gentoo thing.  What
> should the permissions be for this?  Or does gentoo do their own thing
> and there is a different "standard" way of handling this?

This sounds like a Gentoo thing. The location of all the various pg
files is a compile time option and lots of packagers make different
decisions based on their distro layouts. Ubuntu / Debian for instance
puts all the postgresql.conf type files in
/etc/postgresql/8.x/<clustername>/ and allows you to have multiple
instances of different versions by moving things around from the
default of a single pg install from source.