Search Postgresql Archives

Re: Limit postgres user logins

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux