3

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

Akhilesh Mishra
  • 5,876
  • 3
  • 16
  • 32
Neha Verma
  • 63
  • 2
  • 6
  • Does this answer your question? [How can I connect to my serverless RDS instance from the public internet?](https://stackoverflow.com/questions/67655463/how-can-i-connect-to-my-serverless-rds-instance-from-the-public-internet) – enharmonic Jun 07 '21 at 20:55
  • This has been already done. @enharmonic – Neha Verma Jun 11 '21 at 05:35

1 Answers1

3

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.

Marcin
  • 215,873
  • 14
  • 235
  • 294
  • Yes, my EC2 instance is running on the same VPC. In fact, my database is working fine with my backend server. All the I/O operation is working fine. The only issue which I am facing is that my database is not getting connect with my system pgAdmin 4 software. – Neha Verma Jun 01 '21 at 09:11