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