From: | JDT <jdthoosier(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Superuser access for Heroku Postgresql? |
Date: | 2016-10-01 12:24:52 |
Message-ID: | CAEuEvFDHydUuYY=mezevk8q_eWb=3Zy3E0JL0A6u=Hev5fpZHA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I'm a long-time Oracle DBA moving over to take on other things, recently
becoming involved
with Heroku Postgres. I've not worked with Postgresql before.
From what I've seen, it does not look like superuser is available. The
"postgres" role is locked
down, and the owner of the database provisioned does not have a number of
privileges,
including superuser. My understanding is that by default, you need to
use O/S authentication
to access the postgres role; and with Heroku you do not have that.
What is the situation here? It looks as though why I can do things such
as add extensions,
add schemas, and so on; but I cannot add roles. It seems as though you
get that one database
with it's owner, and that is it. And everyone who needs to work with
this database uses that
same owner/password.
Heroku documentation is not forthcoming on how their add-on flavor of
Postgresql differs from a
functional POV from a full-blown local setup.
Thanks,
JDT
From | Date | Subject | |
---|---|---|---|
Next Message | Subramani, Saravanan | 2016-10-03 10:11:36 | oracle fdw |
Previous Message | Poul Kristensen | 2016-09-29 18:47:46 | Re: /var/run/postgresql/.s.PGSQL.5432 should be 5433 |