Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6])
	by hub.org (8.9.3/8.9.3) with ESMTP id UAA02948
	for <pgsql-interfaces@postgreSQL.org>;
	Mon, 24 May 1999 20:12:21 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id UAA01623;
	Mon, 24 May 1999 20:11:49 -0400 (EDT)
To: "Michael R. Anderson" <mike@ferrar.wvsc.edu>
cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] dynamic IPs 
In-reply-to: Your message of Mon, 24 May 1999 16:11:44 -0400
	<01BEA600.1ED46780@ferrar.wvsc.edu>
Date: Mon, 24 May 1999 20:11:49 -0400
Message-ID: <1621.927591109@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

"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