title: can't connect to redshift database
body: <p>I'm trying to connect to Redshift database from SQL Workbench/J using Postgre JDBC drivers but I can't get through. I get this error "The connection attempt failed". The jdbc driver is properly located. I also tried through Aginity Workbench for Redshift but it was unable to show the list of databases. I have my connection url to the database of the form <code>jdbc:postgresql://host:port/name_of_database</code> but surprisingly I could not even ping the host. I can see that the health of database is good through amazon console. So, my questions are:</p>
  
  <ol>
  <li>Why can't I ping my redshift db server?</li>
  <li>Is there a way to ssh to the db server?</li>
  </ol>
  
  <p>Edit1: After adding my public IP to security group the host gets resolved while pinging but still there's 100% packet loss.</p>
  
  <p>Edit2: I could successfully host the db in EC2-Classic but not in EC2-VPC. Since I'm running short of public IPs I tried re-hosting the db in VPC where there is 100% packet loss.</p>