Description
You may encounter following Errors with Database connectivity issues:
"Connector was unable to connect to the database due to a connection issue. The connector will continue to retry but if the error persists ensure that the database is reachable and your credentials are valid."
"Connector failed with 'Connection Refused' error when trying to connect to <database host:port>. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections."
"Could not connect to the database: password authentication failed for user "<database user>". Please make sure that the user credentials are valid."
Applies To
PostgresCDCsourceV2 Connector
Confluent Cloud
Cause
You may hit this issue because of the database is not reachable, or the user credentials used to connect database in not correct
Resolution
1. The connector will continue to retry but if the error persists then please ensure that the database is reachable and the db user credentials are valid.
2. Connector failed with 'Connection Refused' error when trying to connect to <database host:port>.
Check that hostname and port are correct and that the postmaster is accepting TCP/IP Connections.
3. Make sure that the Database username and the password configured in the connector are valid, and user account is not locked out because of the invalid password usage.