Re: Local authentication/security - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Local authentication/security
Date
Msg-id 200708232311.05244.peter_e@gmx.net
Whole thread Raw
In response to Local authentication/security  ("Lange Marcus" <marcus.lange@saabgroup.com>)
List pgsql-general
Lange Marcus wrote:
> I would like to be able to restrict the access to a database so that
> only a specific program running on the same machine can access it,

In postgresql.conf, set

unix_socket_permissions = 770
unix_socket_group = postgres

and make your program setgid postgres.  Or some variant of this
involving those parameters.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-general by date:

Previous
From: Shelby Cain
Date:
Subject: Re: FATAL: could not reattach to shared memory (Win32)
Next
From: Decibel!
Date:
Subject: Re: Automating logins for mundane chores