Connection Attempt Timeout When Connecting To Postgres DB Using IAM Authentication

[Amraafat]

Topic

Postgres Connection Error

Relevant information

I have enabled IAM authentication on my database. When I tried to connect using a token, I initially received a 'connection attempt timeout' error. However, after several attempts (3-6), the connection eventually succeeded.

The problem was not in the login, because I can log in but it sometimes took too long after many trials before connecting, and this is a hassle for the developers if they need to connect fast, and for sure I don't want to use a username and password for them for better security

The following errors appear in the logs:

• pam_authenticate failed: Permission denied
• connection attempt timeout
• FATAL: canceling authentication due to timeout
• HTTP/1.1 503 Service Unavailable

Note:

• I am using DBeaver to connect to the DB.
• I am assuming a role in another account before generating the token.
• I am using the same command to generate the token each time, and I have verified that the session is not expired.

What could be the issue that prevents the connection from succeeding on the first attempt?

What I checked:

• I checked the policy and the db-user.
• I checked the security group.
• I checked IAM authentication is enabled
• Increased the 'authentication_timeout' in the parameter group
• Increased the 'connection timeout' in the Dbeaver setting

[marcosmarxm]

Is this a problem with airbyte-db or postgres connector?

[Amraafat]

postgres connection

[marcosmarxm]

So I kindly ask you to report using the correct template for connector issues.