title: cannot access AWS redshift (EC2-classic) from SQL workbench in local computer despite all open Security Group
body: <p>This question is <strong><em>NOT the same</em></strong> as: <a href="https://stackoverflow.com/questions/25845396/aws-ec2-and-redshift-security-group-connection-error"><strong>AWS EC2 and Redshift Security group connection error</strong></a></p>
  
  <p>i am trying to access my RedShift (using <strong><em>EC2-classic</em></strong> and not using <strong><em>VPC</em></strong>) from SQL workbench in my local computer. The EC2 security group used in my redshift allows: </p>
  
  <p><code>All TCP</code>, </p>
  
  <p><code>All UDP</code>, </p>
  
  <p><code>ALL ICMP</code> </p>
  
  <p>from sources <code>0.0.0.0/0</code> </p>
  
  <p>over port numbers <code>0-65535</code></p>
  
  <p>It still says "<strong>Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections</strong>". </p>
  
  <p>What am i missing out?</p>
  
  <hr>
  
  <hr>
  
  <hr>
  
  <h2>Redshift cluster security group screen</h2>
  
  <p><img src="https://i.stack.imgur.com/dwej2.png" alt="Redshift cluster security group screen"></p>
  
  <hr>
  
  <hr>
  
  <hr>
  
  <h2>EC2 security group screen</h2>
  
  <p><img src="https://i.stack.imgur.com/6LddF.png" alt="EC2 security group screen"></p>
  
  <hr>
  
  <hr>
  
  <hr>