Amazon RDS for PostgreSQL Error: Unable to Validate Certificate

Issue

When setting up or testing a connection, the following error appears:

Unable to validate certificate. We could not connect to Source due to the invalid credentials. Please update the credentials.

Although the error message refers to invalid credentials, the Fivetran Platform Connector logs show the following underlying error:

org.postgresql.util.PSQLException: FATAL: database "<database_name>" does not exist

Environment

• Connector: Amazon RDS for PostgreSQL

Resolution

To resolve this issue, do the following:

1. In Fivetran, go to your Amazon RDS for PostgreSQL connection page.
2. Select the Settings tab.
3. Click Edit connection.
4. Make a note of the database name specified in the Database field.
5. Log in to your PostgreSQL server using psql or your preferred database client.
6. List the available databases.
7. Verify that the database name specified in the Fivetran connection setup form matches an existing database on the server.
8. If the database doesn’t exist, either create it or identify the correct existing database name.
9. In Fivetran, update the Database field with the correct database name.
10. Click Save & Test.

If the error persists, verify that the Fivetran user has CONNECT privilege on the database:

GRANT CONNECT ON DATABASE <db_name> TO <fivetran_user>;

Cause

This issue occurs when the database name configured in Fivetran doesn't match an existing database on the PostgreSQL server. When this happens, PostgreSQL rejects the connection attempt.