On Saturday 9. January 2010 22.20.36 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? In Gentoo, you must add the database owner (probably your own username) to the group Postgres. This was changed with 8.3, and if you had read the message from emerge, you should have noticed. And, yes, I fumbled a lot with this myself. regards, -- Leif Biberg Kristensen http://solumslekt.org/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
