RDS - Aurora PostgreSQL Won't connect in datagrip.
I am trying to connect to my Aurora PostgreSQL db, you must forgive me for I am new to AWS.
these settings keep returning this error in datagrip
DBMS: PostgreSQL (no ver.) Case sensitivity: plain=mixed, delimited=exact The connection attempt failed.
The hostname is the endpoint for my RDS database, which is for this case just called Database-1
The user I scribbled out but its the one prescribed to me in the IAM Identity Centre by my company and lastly the credentials are the aws_access_key_id, aws_secret_access_key and aws_session_token the ones you find in Command Line or Programmatic access.
As I said I am new so there could be a simple fix or something I'm missing so I apologise if this is a waste of time, I am just in deep need of help at this point
- Newest
- Most votes
- Most comments
2 things here comes to mind.
A) how are you connecting to postgress? Over the intent or a private link such as VPN? Can you resolve the host name your connecting too?
B) does your RDS support IAM authentication? If not you will need a username and password direct in the database engine.
If the client side error is not descriptive enough then maybe you can check in AWS CloudTrail. AWS CloudTrail is an AWS service that helps you audit your AWS account. AWS CloudTrail is turned on for your AWS account when you create it. All Amazon Aurora actions are logged by CloudTrail. CloudTrail provides a record of actions taken by a user, role, or an AWS service in Amazon Aurora.
This page Monitoring Amazon Aurora API calls in AWS CloudTrail provides details.
Relevant content
- Accepted Answer
- Accepted Answerasked 4 months ago
AWS OFFICIALUpdated 2 months ago- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 years ago
- How do I end long-running queries in my Amazon RDS for PostrgreSQL or Aurora PostgreSQL DB instance?AWS OFFICIALUpdated 10 months ago
Hi Gary thank you so much for your response, I'm connecting with the endpoint listed in the RDS portal on that specific database. The RDS does infact support IAM I believe as the company systems admin enabled it on the DB as per my request. What makes me think the host is being resolved is in this instance, it takes quite a while before bouncing an error. Whereas if I change the hostname, it will bounce the error instantly. This leads me to believe its authentication but without the proper error code, I have no way of knowing.