Обсуждение: User Login Authentication from Multiple IP Addresses (DHCP)? pg_ hba.conf

Поиск
Список
Период
Сортировка

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

От
David Wagoner
Дата:

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

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

От
Thomas F.O'Connell
Дата:
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