Re: Local authentication/security

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/