Unable to connect Postgres database which is on Amazon cloud server

bhaskarkothavt — Thu, 06 May 2021 12:04:04 GMT

Hello,

I am trying to connect Postgres database which is reside in Amazon cloud and i am getting the an error, could any one please help me in resolving this issue?

Scenario 1:

LIBNAME Lib_PDV postgres user=&useridpd pwd=&password3 server="postgres-db.cwjq1vc8yci6.us-east-1.rds.amazonaws.com" database=udc_data_dev conopts="sslmode=require";

ERROR: CLI error trying to establish connection: SSL SYSCALL error: Connection reset by peer
(0x00002746/10054)
ERROR: Error in the LIBNAME statement.

Scenario 2:

libname Lib_PDV postgres user=&useridpd pwd=&password3 server="postgres-db.cwjq1vc8yci6.us-east-1.rds.amazonaws.com" database=udc_data_dev conopts="sslmode=prefer";

ERROR: CLI error trying to establish connection: SSL SYSCALL error: Connection reset by peer
(0x00002746/10054) FATAL: no pg_hba.conf entry for host "128.173.240.192", user
"udc_data_dev_strategic_analysis_data_owner", database "udc_data_dev", SSL off
ERROR: Error in the LIBNAME statement

Thanks & Regards,

Bhaskar

topic Unable to connect Postgres database which is on Amazon cloud server in SAS Data Management

Unable to connect Postgres database which is on Amazon cloud server