If I don't use SSL the connections works ok. Also I have been able to use the SSL connection with psql command-line client (using sslmode=verify-ca) and pgAdmin too. So server configuration should be ok.
My connection string looks like:
Code: Select all
User Id=user;Password=*****;Host=xxx.rds.amazonaws.com;Database=dbname;Unicode=True;Persist Security Info=True;SSLMode=Require;SSL CA Cert=C:\rds-combined-ca-bundle.pem
The error I get always when "Test Connection" is "Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. Inner error: An existing connection was forcibly closed by the remote host.".
Situation looks a bit same as this:
viewtopic.php?t=33971