Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Connecting to a Redshift cluster from pgAdmin

Tags:

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?

like image 284
Justin Avatar asked Mar 08 '13 02:03

Justin


1 Answers

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.

like image 174
Joe Harris Avatar answered Oct 10 '22 03:10

Joe Harris