pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUser 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>
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-07 22:05 Thomas F.O'Connell <tfo@sitening.com>
parent: David Wagoner <dwagoner@arsenaldigital.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