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