Close

Regola di automazione di Jira quando una pull request viene sottoposta a merge

Connect to your PostgreSQL server instance using pgAdmin > right-click on ‘Group Roles’ and select ‘New Group Role’.

No need to create a password for the Group role

Give the role a descriptive name > click ‘OK’.  You do NOT need to create a password for the Group role; we will create a password for the Login role created later in this document.

Select the database that you would like Chartio to connect to as the Default database

Expand ‘Databases’ > right-click on the database you would like to connect to Atlassian Analytics > select ‘Properties’.

Click the database you would like to conenct to Chartio

In the ‘Privileges’ tab select the newly created group from the ‘Role’ drop-down menu > check the ‘Connect’ box > click ‘Add/Change’ > click ‘OK’.

Click the Connect box in the Priviledges tab and choose OK

Click the expand arrow next to your database > expand ‘Schemas’ > right-click ‘public’ > select ‘Grant Wizard’.

Select Grant Wizard

On the ‘Selection’ tab click ‘Check All’.

Click check all

In the ‘Privileges’ tab select the newly created group from the ‘Role’ drop-down menu > check the ‘Select’ box > click ‘Add/Change’ > click ‘OK’.

If your schema is not ‘public’, you will also need to grant USAGE permissions on the schema.

Grant USAGE permissions, if necessary

Under your server tree right-click ‘Login Roles’ > select ‘New Login Role’

Right-click to select New Login Role

Type a descriptive name for the user.

Add a name

On the ‘Definition’ tab enter a secure password.

Enter a password

On the ‘Role membership’ tab add the newly create group to the ‘Member’ window > click ‘OK’.

Final result

You have successfully created a new read-only user for your database.  Use the credentials created for the Login role when setting up your PostgreSQL connection for Atlassian Analytics.

For information on creating a user with psql, see this article.

For more information on connecting your PostgreSQL database to Atlassian Analytics, see our documentation.


Argomento successivo