Perform DBA-type tasks in Aiven for PostgreSQL®#

Aiven doesn’t allow superuser access to Aiven for PostgreSQL® services. However, most DBA-type actions are still available through other methods.

avnadmin user privileges#

By default, in every PostgreSQL instance, an avnadmin database user is created, with permissions to perform most of the usual DB management operations. It can manage:

  • Databases (CREATE DATABASE, DROP DATABASE)

  • Database users (CREATE USER/ROLE, DROP USER/ROLE)

  • Extensions (CREATE EXTENSION), you can also view the list of available extensions

  • Access permissions (GRANT, REVOKE)

  • Logical replication with the REPLICATION privilege

Tip

You can also manage databases and users in the Aiven web console or though our REST API.

aiven_extras extension#

The aiven_extras extension, developed and maintained by Aiven, enables the avnadmin to perform superuser-like functionalities like:

You can install the aiven_extras extension executing the following command with the avnadmin user:

CREATE EXTENSION aiven_extras CASCADE;

For more information about aiven_extras check the GitHub repository for the project.