Re: SSL connection getting rejected on AWS RDS

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

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

> 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

SSL connection getting rejected on AWS RDS

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. Could you please advise? Password for user lmp_cloud_dev: psql: FATAL: PAM authentication f

Re: AWS RDS PostgreSQL CPU Spiking to 100%

Thanks, I'll check it out. On Mon, Sep 28, 2020 at 9:40 PM Prince Pathria wrote: > We faced a similar issue, adding RDS proxy in front of RDS Postgres can > help. > In our situation, there were a lot of connects/disconnects from Lambda > functions although concurrency of Lambda was 100 only. > A