Re: Local authentication/security

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: "Lange Marcus" <marcus(dot)lange(at)saabgroup(dot)com>
Subject: Re: Local authentication/security
Date: 2007-08-23 21:11:04
Message-ID: 200708232311.05244.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2007-08-23 22:22:25 Re: Geographic High-Availability/Replication
Previous Message Shelby Cain 2007-08-23 21:03:07 Re: FATAL: could not reattach to shared memory (Win32)