gvim wrote:
My hba file has:

local   all         postgres                                    md5
host    all         admin         127.0.0.1/32          md5
host    all         dbuser        127.0.0.1/32          md5

But that still allows users other than postgres to attempt to login as postgres. Is there any way I can limit access to the postgres user specified as being logged in as postgres?


on the first line (and only the first line), change md5 to ident sameuser [leave sameuser off on 8.4]

then the postgres user can only log on as himself and noone else can.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to