I am trying to migrate on prem MYSQL to Postgres SQL on RDS instance but endpoint connection is failed


Below is the error i have allowed all rules and traffic still getting same error , as of now i am using latest version of postgresSQL 16

Please anybody help me to resolve this issue.

Test Endpoint failed: Application-Status: 1020912, Application-Message: Cannot connect to ODBC provider Network error has occurred, Application-Detailed-Message: RetCode: SQL_ERROR SqlState: 08001 NativeError: 101 Message: FATAL: no pg_hba.conf entry for host "", user "postgres", database "mydb", no encryption

1 Answer

"FATAL: no pg_hba.conf entry for host" errors indicate that there was a failed authentication attempt to the database, so the connection couldn't be established. This can happen because of different reasons:

  1. The authentication failed because the user/password credentials were invalid: ((user "xxxx", database "yyyy")). This could happen if you're trying to connect to the database using wrong or revoked credentials.

  2. The authentication failed because the connection didn't use SSL encryption: (SSL off). If your client is not using SSL to connect to your database, you would see these errors even if you're using the right credentials to connect to it.

  3. The authentication failed because the client environment had previously been configured for certificate-based Postgres authentication (mTLS) but the current server is not configured for certificate-based authentication. Look for a .postgresql subdirectory in your current user HOME directory and remove or rename any postgresql.crt subdirectory in there.

Looks like your client is not using SSL to connect to the database.

profile pictureAWS
answered 2 months ago
profile picture
reviewed 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions