55.1. Creating an Instance Role #
In the navigation panel, go to Infrastructure → Instances.
Click the name of the instance.
In the navigation panel, go to System roles.
In the top-right corner of the page, click Create role.
Specify parameters of the new instance role (parameters marked with an asterisk are required):
Name.
Role privileges.
You can assign privileges to the instance role using the following checkboxes:
Login: Specifies whether the instance role has the
LOGINprivilege.Superuser status: Specifies whether the instance role has the
SUPERUSERprivilege.Creating roles: Specifies whether the instance role has the
CREATEROLEprivilege.Creating databases: Specifies whether the instance role has the
CREATEDBprivilege.Inheriting privileges: Specifies whether the instance role automatically inherits privileges of roles it is a member of.
Replication: Specifies whether the instance role is a replication role. Such roles can initiate replication connections, as well as create and drop replication slots.
Bypass RLS: Specifies whether the instance role bypasses row-level security policies.
For more information, refer to the official Postgres Pro documentation on row security policies.
Connection limit: The maximum number of concurrent connections that the instance role can make.
This only applies to instance roles that can connect to the server.
Valid until: The password expiration time for the instance role.
This is only used for password authentication.
Member of: Instance roles that include the role as a member.
To add an instance role, click Add role and select it.
Includes roles: Instance roles that are members of the role.
To add an instance role, click Add role and select it.
Click Create.