我正在尝试从PgAdmin 3连接AWS RDS PostgreSql.我点击了以下链接 docs.aws.amazon/AmazonRDS/latest/UserGuide/USER_ConnectToPostgreSQLInstance.html
I am trying to connect AWS RDS PostgreSql from PgAdmin 3. I followed the below link docs.aws.amazon/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 8299
$nc -zv postgresql1.c6c8mn7tsdgv0.us-west-2.rds.amazonaws 8299
与postgresql1.c6c8mn7tsdgv0.us-west-2.rds.amazonaws的连接 8299端口[tcp/vvr-data]成功!
Connection to postgresql1.c6c8mn7tsdgv0.us-west-2.rds.amazonaws 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 8299
C:>telnet sg-postgresql1.c6c8mntzhgv0.us-west-2.rds.amazonaws 8299
连接到sg-postgresql1.c6c8mntzhgv0.us-west-2.rds.amazonaws ...无法 在端口819上打开到主机的连接:连接失败
Connecting To sg-postgresql1.c6c8mntzhgv0.us-west-2.rds.amazonaws...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
发布评论