Unable to connect to server: timeout expired AWS aurora rds

Question

I am trying to connect my AWS aurora database with pgAdmin 4 and it throws this error. I have tried all the previous solutions provided by the stack overflow answers like add inbound my IP and update pg_hab.conf. It still not working for me. Thank you in advance.

Error facing with pgAdmin

Answer 1

Aurora serverless can be only accessed from within VPC. It has no public Ip address. From docs:

You can't give an Aurora Serverless v1 DB cluster a public IP address. You can access an Aurora Serverless v1 DB cluster only from within a VPC.

This means you either have to connect to it from an EC2 instance running in the same VPC, or setup ssh tunneling or VPN connection between your local computer and the aurora. How to setup ssh tunnel is explained here and here.

Alternatively, use DATA API to interact with your database from outside of a VPC.