title: Connecting to a Redshift cluster from pgAdmin
body: <p><em>UPDATE</em>: also asked on the PgAdmin-support mailing list <a href="http://www.postgresql.org/message-id/CAAD1YJpBtgvJ+6Wk8NFOJORJVu5YH7Jtg9P-TRy88=Q4DmbPzg@mail.gmail.com" rel="noreferrer">here</a>.</p>
  
  <hr>
  
  <p>So I have an AWS Redshift cluster up and running, and I'm able to connect to it from the command line with </p>
  
  <p><code>$ psql -h host -d database -p port -U username</code></p>
  
  <p>I want to connect to the cluster through pgAdmin III, but after I connect to the cluster, I get an error that states:</p>
  
  <blockquote>
    <p>Error: Must be superuser to view default_tablespace</p>
  </blockquote>
  
  <p>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.</p>
  
  <p>Now, if I connect via psql, and I check:</p>
  
  <p><code>$ \tu</code></p>
  
  <p>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? </p>
  
  <p>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?</p>