Trouble connecting to RDS PostgreSQL Aurora instance in the same VPC

Summary

Error ‘connection not available’ encountered when trying to connect to RDS PostgreSQL Aurora instance in the same VPC, while plsql connects successfully from the EC2 shell.


Question

help. I cannot connect to my RDS PostgreSQL Aurora instance in the same VPC even though plsql connects without issues from the ec2 shell

airbyte-bootloader error “connection not available”

airbyte-bootloader  | org.jooq.exception.DataAccessException: Error getting connection from data source HikariDataSource (HikariPool-2)```
```# this is working without issues:

psql --host=${DATABASE_HOST} --port=${DATABASE_PORT} --username=${DATABASE_USER} --password --dbname=airbyte```

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1715278743870969) if you want to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["rds-postgresql-aurora", "vpc", "connection-issue", "airbyte-bootloader", "psql"]
</sub>