Superuser access for Heroku Postgresql?

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

Browse pgsql-admin by date

  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