Re: [ADMIN] unix_socket_group problem

2009-11-13 Thread Joe Miller
On Fri, Nov 13, 2009 at 12:38 PM, Tom Lane wrote: > > Perhaps postgres isn't a member of myadmin? > > That's what I was missing -- thanks Tom. Joe

Re: [ADMIN] unix_socket_group problem

2009-11-13 Thread Tom Lane
Joe Miller writes: > If I set this: > unix_socket_group = 'myadmin' > unix_socket_permissions = 0777 > ...connection is refused for all accounts. Have you checked the postmaster's log to see if it's reporting any problems? I'm wondering if the chown() call is failing. Perhaps postgres isn't a

Re: [ADMIN] unix_socket_group problem

2009-11-13 Thread Joe Miller
On Fri, Nov 13, 2009 at 11:47 AM, Tom Lane wrote: > Joe Miller writes: > > I have a PostgreSQL installation for which I would like to limit local > > domain socket access to the postgres user and members of the "myadmin" > > group. I've modified pg_hba.conf to trust local domain socket > connect

Re: [ADMIN] unix_socket_group problem

2009-11-13 Thread Tom Lane
Joe Miller writes: > I have a PostgreSQL installation for which I would like to limit local > domain socket access to the postgres user and members of the "myadmin" > group. I've modified pg_hba.conf to trust local domain socket connections, > and changed these settings in postgresql.conf: > unix_