Re: Connect to PostgreSQL server from an ADSL connection

Szabolcs,

On Jan 1, 2006, at 2:05 PM, Szabolcs Andrási wrote:

> The documentation says about the "listen_addresses" configuration
> parameter in the postgresql.conf file, that to accept TCP/IP
> connections its value must be '*' or at least its value must contain
> the host names on which the server is listening for connections from
> client applications. So I guess I should add "my.dyndns.domain" to it
> to accept TCP/IP connection from that remote computer.
> But I don't know if am I right? How should I configure the pg_hba.conf
> file? What else should I do? Or just explain more detailed (through
> the example above) that SSH connection please...
> Could you please help me?

Here is a bit more detail about SSH tunneling with PostgreSQL:

http://pgedit.com/tip/postgresql/ssh_tunneling

As far as your original question, I don't think there is a solution.
pg_hba.conf requires IP addresses and will not work with domain
names. The possibility of changing this is currently being discussed
on the hackers list.

I suppose if you were really industrious and had the right access you
could write a script updates the pg_hba.conf file if the dynamic
address changes. I would also like to see DNS names supported in
pb_hba.conf.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL