RDS - Aurora PostgreSQL Won't connect in datagrip.

0

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

DataGrip Panel

example db name

2 個答案
0

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.

profile picture
專家
已回答 10 個月前
  • 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.

0

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.

profile pictureAWS
已回答 10 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南