Re: SSL connection getting rejected on AWS RDS

2020-09-30 Thread Hannah Huang
Hi Aditya, Yes, you need to grant the role to the user inside PostgreSQL database. Please checkout this article: https://suyahuang.wordpress.com/2020/10/01/hands-on-lab-access-rds-postgresql-from-ec2-instance-without-password-how-to-configure-iam-db-authentication/ Let me know if you have any p

Re: SSL connection getting rejected on AWS RDS

2020-09-30 Thread aditya desai
Hi Hannah, Thank you very much!! this is really helpful. Do we need to pass 'sslrootcert" as mentioned in the doc below? I see that you have not used it in your command. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.IAMDBAuth.Connecting.AWSCLI.PostgreSQL.html Also do we hav

Re: SSL connection getting rejected on AWS RDS

2020-09-30 Thread Hannah Huang
> On 30 Sep 2020, at 5:19 pm, aditya desai wrote: > > Hi, > We have AWS RDS and we are trying to connect to DB remotely from EC2 > instance.as client connection using psql. We are trying > to set up IAM roles. We did all the necessary settings but got below error. > Cou