Skip to main content

User and schema management in Aiven for PostgreSQL®

Perform DBA tasks and manage schema ownership and access for your Aiven for PostgreSQL® service.

aiven_extras closes part of the superuser gap​

Aiven doesn't grant superuser access on Aiven for PostgreSQL® services. The aiven_extras extension closes part of that gap, but only for specific tasks. Claiming ownership of the public schema needs it, while setting up read-only access to databases or tables doesn't.

Before you start​

  • Claiming the public schema requires aiven_extras, because that schema starts out owned by an internal postgres user, not avnadmin.
  • Restricting access to databases or tables with read-only roles doesn't require the extension. You can set it up with standard GRANT and REVOKE statements.

Related pages