Connecting to a Redshift cluster from pgAdmin
UPDATE: also asked on the PgAdmin-support mailing list here.
So I have an AWS Redshift cluster up and running, and I'm able to connect to it from the command line with
$ psql -h host -d database -p port -U username
I want to connect to the cluster through pgAdmin III, but after I connect to the cluster, I get an error that states:
Error: Must be superuser to view default_tablespace
Note, the fields I entered were: Name, Host, Port, Maintenance DB, Username, and Password, all of which were entered the same as with the psql command.
Now, if I connect via psql, and I check:
$ \tu
This user [the master user granted by AWS] is, in fact, a superuser. So are there any suggestions for what might be the cause of this error?
As a follow up question, when I connect to other remote dbs, I don't get this error even though I am not a superuser, so what is happening here? What about Redshift causes this error to happen when connecting via pgAdmin?
Answer
PGAdmin 1.6.3 (from March 2007!) is working fine for me (on OS X) with Redshift.
This makes sense I guess, given that Redshift was forked from Postgres 8.0.
NOTE: by 'fine' I mean the things that I want from a GUI work OK. There are still a few quirks and error messages to be dismissed.