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