Re: Limit postgres user logins - Mailing list pgsql-general

From John R Pierce
Subject Re: Limit postgres user logins
Date
Msg-id 4BC7A17F.1040705@hogranch.com
Whole thread Raw
In response to Limit postgres user logins  (gvim <gvimrc@googlemail.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: gvim
Date:
Subject: Limit postgres user logins
Next
From: "Joshua D. Drake"
Date:
Subject: Re: pl/java status