Re: Limit postgres user logins

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.