On Sat, Jan 9, 2010 at 2:20 PM, <felix@xxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
