Unable to connect to Redshift from psql?

Question

I am using the following command to log into my redshift cluster:

psql -h my-cluster.ho46wegweg423.ap-southeast-1.redshift.amazonaws.com -p 5439 -U username

This prompts me to enter password for username and I get the following error:

psql: FATAL: database "username" does not exist

I am able to log into the cluster from SQLWorkbench/J but not from command line.

Answer 1

You need to specify database name "-d my_database" after the hostname.