From: | Justin Yan <justin(dot)d(dot)yan(at)gmail(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | pgAdmin and AWS Redshift Connection problems |
Date: | 2013-03-08 07:04:20 |
Message-ID: | CAAD1YJpBtgvJ+6Wk8NFOJORJVu5YH7Jtg9P-TRy88=Q4DmbPzg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hello!
AWS Redshift, while proprietary, allows one to connect through any client
that utilizes Postgres 8.0 drivers. Approximately a week ago, I tested
connecting to a Redshift cluster through pgAdmin v1.12.3 [for postgres 8.0]
on Ubuntu through the master user which AWS provides, which has superuser
privileges. So:
host = hostname which AWS provides
maintenance db = default db name
user = aws superuser
pw = my pw
port = 5439 [the port redshift uses]
And about a week ago, this all worked. I was able to run queries, see the
results, the whole shebang. As of a few days ago, however, pgAdmin stopped
working. I would use the exact some information to connect, and it would
appear to be connected. However, there would be no databases [it said
databases(0)], and when I tried to expand the databases in the explorer, I
would get the error "ERROR: must be superuser to examine
default_tablespace". I thought, okay, that's strange, so I tried using
psql from the command line on Ubuntu:
$ psql -h hostname -d dbname -p 5439 -U superuser
and I was able to get in, run queries, create tables, all that nice stuff.
What I couldn't do was run the command SHOW default_tablespace; - that
returned the error:
ERROR: must be superuser to examine "default_tablespace"
I found it slightly weird, because if you run the \du command, it says:
Role name | Attributes | Member of
-----------+----------------------+-----------
myuser | Superuser, Create DB |
After asking around, it was chalked up to AWS tweaking the internal
workings to prevent users from doing certain things, so I don't think
there's anything pgAdmin can necessarily do about that. What I am curious
about, however:
is it possible to get around this in pgAdmin? Why is it I can query the
databases in psql, but not pgAdmin, and is it something that can be worked
around in pgAdmin?
Thanks for your help!
Justin
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2013-03-08 12:00:31 | Re: pgAdmin and AWS Redshift Connection problems |
Previous Message | Jan-Peter Seifert | 2013-03-04 13:43:20 | Re: Problem with pgAdmin and Server Status encode |