PostgreSQL

Accessing the list of instances

To view the list of instances on PostgreSQL, follow these steps:

1. Navigate to Database.

2. A list of PostgreSQL instances will be displayed in a tabular fashion, containing the following data:

   1. Name: Name of instance

   2. IP: IP address of instance

   3. Environment: Environment in which instance is deployed

   4. Project: Project with which the instance is associated with

Creating a new instance

1. Navigate to Database.

2. Select Create New Instance.

3. In the Create Database pop-up window, configure the following fields:

   1. Instance Name

   2. Database Version

   3. Project

   4. Network

   5. Machine size

   6. Disk Size

   7. Availability

1. Click Request Instance. An approval request will be sent to the user's reporting manager.

2. Once approved, the instance will be created.

Editing an existing instance

To edit an existing instance, follow these steps:

1. Navigate to Database.

2. Search for the instance you wish to edit using the Search bar.

3. In the Instance table, navigate to the Edit column on the right and click the Edit icon.

1. The following drop down will become visible:

   1. Users & Databases

   2. Add Service

   3. Request Access

Viewing list of Users and Databases

1. Follow the steps from before.

2. Select Users & Databases from the dropdown.

3. In the pop-up window, the list of users and databases associated with the instance will be displayed.

Adding a new service

1. Follow the steps from before.

2. Select Add Service from the dropdown.

3. In the pop-up window, configure the following:

   1. User Name

   2. Secret Name

   3. Database Name

   4. Project (non configurable)

1. Click Request. An approval request will be sent to the user's reporting manager.

2. Once approved, the new service will be added.

Requesting access

1. Follow the steps from before.

2. Select Request Access from the dropdown.

3. In the pop-up window, select the relevant databases.

4. Click Request.

1. Click Request. An approval request will be sent to the user's reporting manager.

2. Once approved, the access for the database will be granted.