osx - How to connect to aws Redshift db from mac -

osx - How to connect to aws Redshift db from mac -

i using mac , typically utilize sequel pro interact sql databases. utilize mysql, understand redshift uses postgres.

when seek connect redshift db, should utilize ip, or "endpoint"?

also when seek connect, error sequel pro.

unable connect host {{my_db_host}}, or request timed out. sure address right , have necessary privileges, or seek increasing connection timeout (currently 10 seconds). mysql said: can't connect mysql server on '{{my_db_host}}' (4)

can offer advice on how connected?

thanks

you should using redshift endpoint, if have security grouping settings configured correctly. might want set grouping 0.0.0.0/0 during testing(this opens cluster entire internet, , can lock downwards later 1 time works)

you need create sure have right odbc/jdbc driver. recommend either netbeans(comes connection driver), sql workbench, or aginity redshift. default port 5439.

i thikn using wrong driver(a mysql driver not psql driver), becaues error says mysql server.

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

for mac, believe seek , utilize terminal psql client. like...

psql -h endpoiint.aws.com -p 5439 -u username -p

osx postgresql amazon-web-services amazon-redshift sequelpro