Connecting to Redshift (which speaks Postgres)

[expired user #8327]'s profile image [expired user #8327] posted 10 years ago in Creating a connection Permalink
Redshift recommends using SQL Workbench/J with the Postgres driver to connect. This works fine, but SQL Workbench/J is way behind HeidiSQL. (see http://docs.aws.amazon.com/redshift/latest/mgmt/connecting-using-workbench.html)

Since the nightly builds now support Postgres, it seems that I should be able to connect to Redshift with HeidiSQL.

When I try to connect I get the following error:

FATAL: database "postgres" does not exist

Has anyone successfully connected to Redshift with HeidiSQL? If so how did you accomplish that?
[expired user #8327]'s profile image [expired user #8327] posted 10 years ago Permalink
I was able to make a connection doing the following. It seems that once I'm connected, it doesn't play quite as nice as MySQL connections do.

So from the HeidiSQL session manager:
NETWORK TYPE: postgres
Hostname: shoppertrak.csf9rkgul6hr.us-east-1.redshift.amazonaws.com
USERNAME: your username
PASSWORD: your password
PORT: 5439
DATABASE: In the tutorial a database name is not specified during the creation process.
If you have not specified a Database name Redshift will create a "dev" database by default so you must specify that here.
A good way of finding out is by viewing the "JDBC URL:" in the redshift console, the default DB will be listed after the port number in the jdbc URL, as you can see the dev DB is listed below.
jdbc:postgresql://YOURCLUSTER.us-east-1.redshift.amazonaws.com:5439/dev?tcpKeepAlive=true

Please login to leave a reply, or register at first.