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