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 USER/ROLE,`` DROP USER/ROLE``)
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.