Background
The edb_admin
role does not have superuser privileges by default. There are some jobs that require superuser privilege.
edb_admin=> \du
List of roles
Role name | Attributes | Member of
-----------------------+------------------------------------------------------------+--------------------------------
...
edb_admin | Create role, Create DB | {pg_monitor,pg_signal_backend}
...
Enable Superuser by self-service
Only BYOA(Bring Your Own Account) clusters have this feature. For those BigAnimal Hosted clusters, superuser privilege can not be granted. It will use pg_ba_admin role instead.
1. Go to Additional Settings when creating clusters or editing existing clusters.
2. Enable Superuser Access as shown in the below screenshot.
3. Save the change.