this is the sequel of "Modifying "pg_hba.conf" file to listen local TCP/IP conection"
I manage to modify pg_hba.conf to listen other PCs and allow them through the firewall, but my problem now is that the addresses are dynamic, so the configuration work for one day, but in the next day the router assigns the addresses randomly and we are in trouble again. When I use mySQL I use to work it around using the machine name as the server, but if I use it in the pg_hba it doesn't work. I show you:
what works:
# TYPE DATABASE USER ADDRESS METHOD # IPv4 local connections: host all all 192.168.1.18/32 md5 what doesn't:
# TYPE DATABASE USER ADDRESS METHOD # IPv4 local connections: host all all the_mch_name/32 md5 Is there any solution besides static IP? Thank you!
أكثر...
I manage to modify pg_hba.conf to listen other PCs and allow them through the firewall, but my problem now is that the addresses are dynamic, so the configuration work for one day, but in the next day the router assigns the addresses randomly and we are in trouble again. When I use mySQL I use to work it around using the machine name as the server, but if I use it in the pg_hba it doesn't work. I show you:
what works:
# TYPE DATABASE USER ADDRESS METHOD # IPv4 local connections: host all all 192.168.1.18/32 md5 what doesn't:
# TYPE DATABASE USER ADDRESS METHOD # IPv4 local connections: host all all the_mch_name/32 md5 Is there any solution besides static IP? Thank you!
أكثر...