Connection Attempt Failed
Applies To | Hevo Edge Pipelines configured to connect directly to any variant of the PostgreSQL Source. |
Error Message Text(s) | org.postgresql.util.PSQLException: The connection attempt failed |
Error Summary
- Hevo Edge is unable to connect to the configured PostgreSQL Source.
Potential Causes
-
The database connection details are incorrect.
-
Hevo’s IP address(es) for your region is not added to the database IP allowlist.
-
The database user authorizing the connection does not have sufficient permissions to access the database.
-
The database Source is terminating the connection.
Suggested Actions
-
Verify that the database connection settings, such as the Database Host and Database Port, specified in the Source configuration screen are correct.
Note: The default port for any PostgreSQL database is 5432. You can confirm the port number of your database with the database administrator.
-
Verify that your Source database is publicly accessible and connections from the public Internet are allowed on the database port.
-
Specify the public IP address of your database as the Database Host.
-
Check if Hevo’s IP address(es) for your region is added to the database IP allowlist.
-
Verify that the Security Group and VPC subnet associated with your Source database allow access from all Hevo’s IP addresses for Amazon RDS databases.
-
Ensure that the Database User specified in the Source configuration screen has the required permissions to access the specified database.
-
Try connecting to your Source database through an SQL client, using the information provided on the configuration screen.