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

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

ytcaudience — Sat, 15 Apr 2023 00:00:59 GMT

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.

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

SASKiwi — Sat, 15 Apr 2023 01:10:01 GMT

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

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

ytcaudience — Mon, 17 Apr 2023 15:11:28 GMT

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;