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:
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;
It is port 5432 on your SAS Compute server that needs to be checked. Try your PSQL command while remotely logged onto this server.
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.