PGAdmin III无法连接AWS RDS [英] PGAdmin III cannot connect AWS RDS

问题描述

我正在尝试从PgAdmin 3连接AWS RDS PostgreSql.我点击了以下链接 http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToPostgreSQLInstance.html

I am trying to connect AWS RDS PostgreSql from PgAdmin 3. I followed the below link http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToPostgreSQLInstance.html

在安全组中，我还添加了PostgreSQL和所有流量，如下所示

In Security Group, I also added PostgreSQL and All traffic as below

启用了可公开访问"标志(在Mark B评论后更新)

The "publicly accessible" flag was enabled (updated after Mark B's comment)

我从PGAdmin3得到了错误

I got the error from PGAdmin3

非常感谢您提出任何建议

Very appreciate for any suggestion

******更新*******

******UPDATE*******

我可以使用家庭wifi成功将pgAdminIII连接到AWS RDS，但是不能使用办公室wifi连接.

I can connect pgAdminIII to AWS RDS successfully using home wifi, but cannot connect using office wifi.

我的担心是:

端口5432被办公室wifi阻塞了吗?

Was the port 5432 blocked by office wifi?

如何在不影响当前API的情况下配置/更新端口? 注意:我当前的API运行良好(CRUD)

How can I configure/update the port without impacting to current API? Note: My current API is working well (CRUD)

推荐答案

是否可以先使用常见的Linux或Windows工具测试与数据库实例的连接?

Can you can test your connection to a DB instance using common Linux or Windows tools first?

在Linux或Unix终端上，您可以通过键入以下命令(用端点和数据库实例的端口替换)来测试连接:

From a Linux or Unix terminal, you can test the connection by typing the following (replace with the endpoint and with the port of your DB instance):

$ nc -zv数据库实例端点端口

$nc -zv DB-instance-endpoint port

例如，以下显示了示例命令和返回值:

For example, the following shows a sample command and the return value:

$ nc -zv postgresql1.c6c8mn7tsdgv0.us-west-2.rds.amazonaws.com 8299

$nc -zv postgresql1.c6c8mn7tsdgv0.us-west-2.rds.amazonaws.com 8299

与postgresql1.c6c8mn7tsdgv0.us-west-2.rds.amazonaws.com的连接 8299端口[tcp/vvr-data]成功！

Connection to postgresql1.c6c8mn7tsdgv0.us-west-2.rds.amazonaws.com 8299 port [tcp/vvr-data] succeeded!

Windows用户可以使用Telnet来测试与数据库实例的连接.请注意，除了测试连接之外，不支持Telnet操作.如果连接成功，则该操作不返回任何消息.如果连接不成功，您将收到以下错误消息:

Windows users can use Telnet to test the connection to a DB instance. Note that Telnet actions are not supported other than for testing the connection. If a connection is successful, the action returns no message. If a connection is not successful, you receive an error message such as the following:

C:> telnet sg-postgresql1.c6c8mntzhgv0.us-west-2.rds.amazonaws.com 8299

C:>telnet sg-postgresql1.c6c8mntzhgv0.us-west-2.rds.amazonaws.com 8299

连接到sg-postgresql1.c6c8mntzhgv0.us-west-2.rds.amazonaws.com ...无法 在端口819上打开到主机的连接:连接失败

Connecting To sg-postgresql1.c6c8mntzhgv0.us-west-2.rds.amazonaws.com...Could not open connection to the host, on port 819: Connect failed

如果Telnet操作返回成功，那么您就很好了.

If Telnet actions return success, then you are good to go.

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