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:
Database users (
CREATE EXTENSION), you can also view the list of available extensions
Access permissions (
Logical replication with the
You can also manage databases and users in the Aiven web console or though our REST API.
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
CREATE EXTENSION aiven_extras CASCADE;
For more information about
aiven_extras check the GitHub repository for the project.