1

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?

asked Oct 29, 2016 at 8:29

1 Answer 1

1

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

answered Oct 29, 2016 at 23:04

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.