CLI error: is server running on host and acceptingTCP/IP connections on port 5432?

[ytcaudience]

Whenever I run the following line of code in SAS Studio:

libname test1 postgres server="192.xxx.xx.xxx" port=5432
user=postgres password='postgres' database=mydb;

I get this error:

ERROR: CLI error trying to establish connection: could not connect to server: Connection timed outIs the server running on host

"192.xxx.xx.xxx" and acceptingTCP/IP connections on port 5432?

Note: I can access the database server "192.xxx.xx.xxx" from a pgadmin UI on machines other than "192.xxx.xx.xxx". 

I can ping to "192.xxx.xx.xxx".

This connects perfectly well from any machine:

psql -h 192.xxx.xx.xxx -U postgres -d postgres

This also works from any machine:

telnet 192.xxx.xx.xxx 5432

Please help.

[SASKiwi]

It is port 5432 on your SAS Compute server that needs to be checked. Try your PSQL command while remotely logged onto this server.

[ytcaudience · Accepted solution]

Thank you for your help @SASKiwi 

The actual problem was that the 192.xxx.xx.xxx address is not reachable from the SAS Studio compute server. 

The solution was that I had to ping my hostname and it revealed the SAS net ip address ("xxx.xxx.xx.xxx") and when I replaced my local server's ip (192.xxx.xx.xxx) with this new SAS net ip address, it WORKED!!!

libname test1 postgres server="xxx.xxx.xx.xxx" port=5432
user=postgres password='postgres' database=mydb;