Re: trust auth in 7.4

On Thu, Jan 22, 2004 at 11:00:25AM -0600, Bruno Wolff III wrote:
> > docs say (19.2.1):
> >
> > When trust authentication is specified, PostgreSQL assumes that anyone who
> > can connect to the server is authorized to access the database as whatever
> > database user he specifies (including the database superuser). This method
> > Which of these is right? I hope the last also holds for 'trust' lines?
>
> Both. The second part says that in pg_hba.conf you can say which postgres
> users can connect to which databases. The first part says that trust
> authentication says that postgres will allow you to be whatever user you
> want without having to prove it in any way.

Well, i think the first part is misleading. Trying it it seems to work
as i hoped. If i have a line like

host somedb bruno 192.168.5.5 255.255.255.255 trust

bruno can connect from 192.168.5.5 but tom can't.

I think the first part should say 'as the users specified in the specific
pg_hba.conf line without doing further checks'.

Never mind.

Regards,

--
Henk van Lingen, Systems & Network Administrator (o- -+
Dept. of Computer Science, Utrecht University. /\ |
phone: +31-30-2535278 v_/_
http://henk.vanlingen.net/ http://www.tuxtown.net/netiquette/