Connection Attempt Failed

Last updated on Dec 15, 2024
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.

Tell us what went wrong