Re: Connecting to Postgresql without IP address

2021-06-30 Thread sivapostg...@yahoo.com
Thanks Ben, It's NOT working.   Already an entry similar to this is there host all all 192.168.1.0 255.255.255.0 md5 And I added the following entry also in the hba file and restarted PG Serverhostssl all all 192.168.1.0/16 md5 And tried to connect using server computer name instead of IP address

Re: Connecting to Postgresql without IP address

2021-06-30 Thread Ben Madin
Your connection string will work as long as there is a DNS entry for PGServer. Your pg_hba.conf will however need to have an IP address/netmask. So if you are connecting from within your local network, you can put something like: hostssl all all 192.168.0.0/16 md5 Hth? On W

Re: Connecting to Postgresql without IP address

2021-06-30 Thread sivapostg...@yahoo.com
Hello, Using PostgreSQL 11 Currently connecting PostgreSQL database from our Powerbuilder application using the IPAddress as Server Name through ODBC driver.  Would like to know whether we can connect naming the computername instead of IP Address ?  If yes, what info to be entered in pg_hba.conf