Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group