Re: [INTERFACES] dynamic IPs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Michael R(dot) Anderson" <mike(at)ferrar(dot)wvsc(dot)edu>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] dynamic IPs
Date: 1999-05-25 00:11:49
Message-ID: 1621.927591109@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

"Michael R. Anderson" <mike(at)ferrar(dot)wvsc(dot)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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Anna Langer 1999-05-25 00:54:52 Questions about INSERT INTO!
Previous Message leif 1999-05-24 22:55:22 [INTERFACES] MSAccess problem deleting rows