Customer Administration Role
Instaclustr-managed PosgreSQL clusters do not provide superuser level privileges. Instead, each cluster is provisioned with an administrator role (insta_admin) that is then granted to a default user (icpostgresql). Further users can be created and also granted insta_admin membership.
By default, the insta_admin role has the following permissions:
- Create and drop databases
- Create and drop users
- Create trusted extensions
- Set permissions