Re: Network authentication - Mailing list pgsql-general

From Doug McNaught
Subject Re: Network authentication
Date
Msg-id 87sm6i6hxw.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Network authentication  (Bob Parnes <rparnes@megalink.net>)
List pgsql-general
Bob Parnes <rparnes@megalink.net> writes:

> I am having trouble connecting to a database on a debian server from a
> client system, also debian. Acccording to the documentation, this is
> possible without a password and offers the following example,
>
> host    template1   all         192.168.93.0      255.255.255.0     \
>   ident sameuser

You need to be running an ident daemon on the client machine, and also
to be aware of the security issues involved with ident.

> In addition I noticed that if I have a second line in the pg_hba.conf file,
>
> host    all         all         192.168.1.0       255.255.255.0     md5
>
> coming before the other line, I can connect to the server database using
> a password. However, if it follows the line, I cannot. Am I doing
> something wrong here also?

Only the first matching line in pg_hba.conf is used.

-Doug

pgsql-general by date:

Previous
From: Paul Tillotson
Date:
Subject: Re: Performance tuning on RedHat Enterprise Linux 3
Next
From: Neil Conway
Date:
Subject: Re: Performance tuning on RedHat Enterprise Linux 3