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.