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.