DHCP and pg_hba.conf - Mailing list pgsql-general

From bryanh@giraffe-data.com (Bryan Henderson)
Subject DHCP and pg_hba.conf
Date
Msg-id 200003070206.SAA02133@giraffe.giraffe-data.com
Whole thread Raw
List pgsql-general
>...the client IP address is assigned dynamically.
>
>That being the case, how does one set up access / security in the
>pg_hba.conf file (since it requires ip addresses)?

It doesn't require IP addresses unless you want to limit access by IP
address.  And since your users don't have predictable IP addresses, you
don't want to limit access by IP address.

So just specify wildcards for the IP address: *.*.*.*  .

Of course, if you want to restrict access some other way, that's another
matter.  Hba allows password authentication, for example.

See the sample file pg_hba.conf.sample for details.

--
Bryan Henderson                                    Phone 415-505-3367
Olympia, Washington

pgsql-general by date:

Previous
From: Ron Atkins
Date:
Subject: Re: [GENERAL] Accounting/inventory systems
Next
From: bryanh@giraffe-data.com (Bryan Henderson)
Date:
Subject: Re: [GENERAL] database corruption?