"Michael R. Anderson" <mike@ferrar.wvsc.edu> writes:
> I'd like to connect to a database from a machine that gets a new IP
> number every time it connects to the ISP. How do I set up the
> pg_hba.conf file to allow this?
I think your only alternative is to find out the range of IP numbers
your ISP might assign (it's probably not large, one C block at most)
and then configure pg_hba.conf to allow access from any address in
that range. For example, if the ISP says 12.34.56.0 - 12.34.56.255,
then you'd put something like
host all 12.34.56.0 255.255.255.0 password
I'd recommend using an authentication method other than "trust" ;-)
regards, tom lane