Обсуждение: DHCP and pg_hba.conf

>...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

Bryan Henderson wrote:

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

I'll have to include that, looks like a nice blanket statement. I will also
look into the password stuff. My intention is to switch to DHCP so I can
test this stuff myself.

Thank you for your help.

-Ron