Unable to connect to AWS redshift database
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