SQL Workbench/J中的Redshift连接问题 [英] Redshift connection issue in SQL Workbench/J

问题描述

我开始学习Amazon redshift，并按照其文档创建集群.

I started learning amazon redshift, and followed its documentation for creating a cluster.

我选择了2个月的免费试用.当我尝试从SQL Workbench/J连接到Redshift db时，它说连接超时错误".

I opted for 2 months free trail. When I try to connect to the Redshift db from SQL workbench/J it says "Connection timed out error".

我检查了一下，然后输入的所有详细信息都是正确的！我正在通过公司LAN从笔记本电脑访问Redshift数据库.我认为这是一个问题.告诉我如何通过公司局域网连接连接到Redshift?

I checked and all the details I have entered are correct! I'm accessing the Redshift db from my laptop through corporate LAN. I think this as an issue. Tell me how to connect to Redshift from my corporate LAN connection?

当我尝试连接时，来自SQL Workbench/J的响应是:

The response from SQL workbench/J when I try to connect is:

[Amazon] [500150]设置/关闭连接时出错:连接超时:连接.

[Amazon][500150] Error setting/closing connection: Connection timed out:connect.

推荐答案

检查您的集群是否具有公共访问权限:转到Redshift控制台以查看是否对公共访问是是".

Check if your cluster has public access: Go to the Redshift console to see if it's "Yes" for Publicly Accessible.

检查安全组是否允许从您的IP访问.您可以使用"nc -v端点端口"来检查群集的端口是否可ping通.

Check if security group allow access from your IP. You can use "nc -v endpoint port" to check if the cluster's port is pingable.

这篇关于SQL Workbench/J中的Redshift连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！