How to connect to aws Redshift db from mac

macos postgresql amazon-web-services amazon-redshift sequelpro
johncorser picture johncorser · Jun 26, 2014 · Viewed 15.6k times · Source

I am using a mac and I typically use Sequel Pro to interact with sql databases. Usually I use mysql, but I understand redshift uses Postgres.

When I try to connect to my Redshift db, should I use the IP, or the "endpoint"?

Also when I try to connect, I get this error from Sequel Pro.

Unable to connect to host {{my_db_host}}, or the request timed out.

Be sure that the address is correct and that you have the necessary privileges, or try increasing the connection timeout (currently 10 seconds).

MySQL said: Can't connect to MySQL server on '{{my_db_host}}' (4)

Can anyone offer advice on how to get connected?

Thanks

Answer

Dan Ciborowski - MSFT picture Dan Ciborowski - MSFT · Jun 26, 2014

You should be using the Redshift Endpoint, if you have your security group settings configured correctly. You might want to set your group to 0.0.0.0/0 during testing(this opens up your cluster to the entire internet, and you can lock it down later once it works)

You also need to make sure you have the correct ODBC/JDBC driver. I recommend either Netbeans(comes with connection driver), SQL Workbench, or Aginity Redshift. Default port is 5439.

I thikn you are using the wrong driver(a mysql driver not psql driver), becaues your error says MySQL server.

http://docs.aws.amazon.com/redshift/latest/gsg/rs-gsg-prereq.html

For mac, I believe you could also try and use the a terminal PSQL client. Something like...

psql -H endpoint.aws.com -p 5439 -U username --password

Related questions

How can I start PostgreSQL server on Mac OS X?

Final update: I had forgotten to run the initdb command. By running this command ps auxwww | grep postgres I see that postgres is not running > ps auxwww | grep postgres remcat 1789 0.0 0.0 2434892 480 s000 R+ 11:28PM 0:00.00 grep postgres This raises the question: …

Read More
psql: FATAL: role "postgres" does not exist

I'm a postgres novice. I installed the postgres.app for mac. I was playing around with the psql commands and I accidentally dropped the postgres database. I don't know what was in it. I'm currently working on a tutorial: http://…

Read More
Postgres could not connect to server

After I did brew update and brew upgrade, my postgres got some problem. I tried to uninstall postgres and install again, but it didn't work as well. This is the error message.(I also got this error message when I …

Read More