AWS RDS Postgres连接失败 [英] AWS RDS Postgres connection failure

问题描述

我正在开始使用AWS RDS.我试图创建一个公共PostgreSQL实例(免费)，并试图通过SQL Workbench从本地笔记本电脑进行连接.我正在按照 https://aws中的说明进行操作.amazon.com/getting-started/tutorials/create-connect-postgresql-db/

I am getting started on AWS RDS. I am trying to create a public PostgreSQL instance (free tier) and trying to connect from my local laptop through SQL Workbench. I am following the instructions from this https://aws.amazon.com/getting-started/tutorials/create-connect-postgresql-db/

但是，当我尝试从SQL Workbench连接时，出现连接尝试失败"错误.我已经验证了步骤，主机名，端口，dbname，以确保我没有丢失任何内容.我仍然无法从SQL Workbench连接.

But, when I try to connect from SQL Workbench, I get "connection attempt failed" error. I have verified the steps, host name, port, dbname to make sure I am not missing any. I am still unable connect from SQL Workbench.

我还需要照顾其他配置吗?有没有一种方法可以调试rds数据库实例是否可访问(ping/telnet)?感谢对此的任何帮助.谢谢！

Do I have to take care of any other configurations? Is there a way to debug if the rds db instance is reachable (ping/telnet)? Appreciate any help with this. Thank you!

推荐答案

您应在Amazon RDS实例上检查以下内容:

You should check the following on the Amazon RDS instance:

• 已将其设置为可公开访问
• 它在公共子网
中
• 它具有一个安全组，该组被配置为允许从端口3306上的IP地址进行入站访问
• 您的本地网络未阻止连接(在家中尝试连接，或通过电话进行束缚)

• It is set to publicly accessible
• It is in a public subnet
• It has a security group configured to permit inbound access from your IP address on port 3306
• Your local network is not blocking the connection (try it from home, or tethered via your phone)

这篇关于AWS RDS Postgres连接失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！