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
... View more