postgresql accept dynamic dns hosts?

Question

I am doing work on a server with a postgresql database from home, where I have a dynamic IP, so I use the no-ip ddns service to map my ip to a host name.

I want to edit the pg_hba.conf file so that I can get into the database from home (not setting it to all hosts), but it doesn't seem to work with the host name. Is there anyway to make it work?

It can be done since v. 9, if your server has your dynamic IP in it's `/etc/hosts` file, and is configured to use the hosts file before querying the DNS. I do this, with a cron job to update the hosts file. — mivk, Jul 08 '20 at 14:24

score 5 · Accepted Answer · answered Oct 21 '11 at 15:23

5

This won't work, because the DNS name in pg_hba.conf needs to match the reverse DNS- IP-to-name- lookup result for your IP address: this is assigned by your connectivity provider, and ddns doesn't touch it (just provides an extra forward- name-to-IP- entry).

answered Oct 21 '11 at 15:23

araqnid

127,052
24
157
134

I stuck with configuring DynDNS for my local. May you look at my question http://stackoverflow.com/questions/27304810/domain-name-for-my-pc-configure-router-how-to please? Thanks! – VB_ Dec 05 '14 at 17:07

score 1 · Answer 2 · answered Oct 21 '11 at 14:05

1

I believe this functionality was introduced in v9.1: http://www.postgresql.org/docs/9.1/interactive/auth-pg-hba-conf.html

If you're using a version prior to that, you could write a cron-fired shell script that does the DNS lookup and dynamically creates the pg_hba.conf file. (You might have to do a HUP after changing it, not sure off the top of my head.)

answered Oct 21 '11 at 14:05

Alex Howansky

50,515
8
78
98

thanks for your reply, my `psql -V` is already at 9.1.1, it doesn't seem to work. – bash- Oct 21 '11 at 14:29

postgresql accept dynamic dns hosts?

2 Answers2