Docker container running on an ec2 instance cant connect to RDS AWS

I can access the RDS by ssh-ing into the EC2 instance, and passing the url and password to psql.

When I try to access the RDS via the docker container running on the EC2 using the same url and password I get the following output.

14:05:57.710 [error] Postgrex.Protocol (#PID<0.162.0>) failed to connect: ** (Postgrex.Error) FATAL 28000 (invalid_authorization_specification) no pg_hba.conf entry for host "144.44.44.444", user "postgres", database "postgres", no encryption

Note: I replaced the host IP with a random value above.

トピック: 分析移行とモダナイゼーションコンピューティングデータベース
タグ: Amazon EC2 Amazon Relational Database Service (RDS)
言語: English

awstas

質問済み 2年前674ビュー

2回答

新しい順
投票が多い順
コメントが多い順

Hello.

I think it's probably RDS PostgreSQL, but I think it can be resolved by setting the "rds.force_ssl" parameter in the RDS parameter group to 0, or by downloading the certificate described in the document below into the container and using it when connecting.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL.html