Re: User Login Authentication from Multiple IP Addresses (DHCP)? pg_ hba.conf

Does this modified example from the documentation not cover your case?

# The zero mask means that no bits of the host IP
# address are considered so it matches any host.
host all all 0.0.0.0 0.0.0.0 md5

http://www.postgresql.org/docs/7.4/static/client-authentication.html

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Mar 4, 2005, at 8:45 AM, David Wagoner wrote:

> I've been reading the docs and FAQs for a method to setup pg_hba.conf
> to allow named users to connect using MD5/password authentication from
> any IP address.  For example, I have a Developer who would login using
> a client app. on his laptop which uses DHCP.
>
> Surely there is a common solution :-).  I'm using PostgreSQL 7.4.1.
>
> TIA
>
>
>
> Best regards,
>
> David B. Wagoner
> Database Administrator