pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
User Login Authentication from Multiple IP Addresses (DHCP)?  pg_ hba.conf
2+ messages / 2 participants
[nested] [flat]

* User Login Authentication from Multiple IP Addresses (DHCP)?  pg_ hba.conf
@ 2005-03-04 14:45 David Wagoner <dwagoner@arsenaldigital.com>
  2005-03-07 22:05 ` Re: User Login Authentication from Multiple IP Addresses (DHCP)? pg_ hba.conf Thomas F.O'Connell <tfo@sitening.com>
  0 siblings, 1 reply; 2+ messages in thread

From: David Wagoner @ 2005-03-04 14:45 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: User Login Authentication from Multiple IP Addresses (DHCP)? pg_ hba.conf
  2005-03-04 14:45 User Login Authentication from Multiple IP Addresses (DHCP)?  pg_ hba.conf David Wagoner <dwagoner@arsenaldigital.com>
@ 2005-03-07 22:05 ` Thomas F.O'Connell <tfo@sitening.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Thomas F.O'Connell @ 2005-03-07 22:05 UTC (permalink / raw)
  To: David Wagoner <dwagoner@arsenaldigital.com>; +Cc: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-03-07 22:05 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-04 14:45 User Login Authentication from Multiple IP Addresses (DHCP)?  pg_ hba.conf David Wagoner <dwagoner@arsenaldigital.com>
2005-03-07 22:05 ` Re: User Login Authentication from Multiple IP Addresses (DHCP)? pg_ hba.conf Thomas F.O'Connell <tfo@sitening.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox