I am trying to migrate to a new PostgreSQL database on Amazon Redshift and get the following error:
Connection to jdbc:postgresql://redshift-cluster-i-created:5439/dev wasn't established. ERROR: code 0
To connect I am using the AWS Schema Conversion Tool->Connect to Amazon RDS for PostgreSQL.
Server name: Cluster-name-as-created-on-redshift
Server port: 5439 as is the default AWS port
Database: left blank to connect to the default database I created
User name and password as created on AWS.
For the Server name I also tried the JDBC URL as per the cluster info on AWS but without the 'jdbc:redshift://' prefix or ':5439/dev' postfix.
Then I tried the public IP address of the AWS cluster for the Server name, then I tried the AWS cluster Endpoint as the Server name.
None worked. Any ideas?
Best Answer
I managed to connect using the full endpoint as given by AWS (less the port number), and then following the instructions to add your IP address to your EC2 vpc security group here:
https://stackoverflow.com/questions/19842720/cant-connect-to-redshift-database/19861418#19861418