SAS POSTGRES conncetivity issue

[raxit143]

Hi All,

Greetings!

We are getting below error while assigning Postgres library in SAS EG. We have SAS ACCESS to PostGres in license.

24        

25         GOPTIONS ACCESSIBLE;

ERROR: Could not load /sas/SASHome/SASFoundation/9.4/sasexe/sasptg (94 images loaded)

ERROR: psqlodbcw.so: cannot open shared object file: No such file or directory

26         libname postgre postgres database=sharedservice user=dbmsowner password=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX;

ERROR: The SAS/ACCESS Interface to POSTGRES cannot be loaded.  The SASPTG   code appendage could not be loaded.

ERROR: Error in the LIBNAME statement.

27        

What can be the resolution?

Thanks & Regards,

Rak**bleep** Shah

[Reeza]

Verify your license and installation first.

*checks what is installed;
proc product_status;run;

*check what is licensed;
proc setinit;run;