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 extensionsAccess 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:
Manage subscriptions
Manage
auto_explain
functionalityManage publications
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.