Creating and Managing PostgreSQL Clusters

Use the PostgreSQL DBaaS workflow to create clusters, view cluster details, manage nodes, and configure database backups.

Getting Started

1. Open Databases.
2. Open PostgreSQL.
3. Review the List Cluster screen.

The cluster list displays previously created database clusters in a table, with details such as cluster name, tenant, and business group.

Creating a PostgreSQL Cluster

1. From the Cluster List screen, click Create.
2. Choose the PostgreSQL version.
3. Click Next.
4. Choose the cluster T-shirt size.
5. Click Next.
6. Enter the cluster configuration.
7. Click Submit.

Setting	Description
Business Group	The business group for the cluster.
Region	The region where the cluster is created.
Environment	The target environment.
VPC	The target VPC.
Subnet	The subnet for the cluster.
Cluster Name	The cluster name.
Cluster Description	Optional description for the cluster.
No. of Nodes	Number of nodes in the cluster.
Load Balancer	Selected by default; uncheck if it is not required.
Username	Database username.
Password	Strong database password.
Confirm Password	Password confirmation.
Storage	Default storage is provided and can be increased.

Viewing Clusters

Open Databases > PostgreSQL to view the cluster list. Each cluster appears as a row in the table.

Click a cluster name to open the cluster details page.

Cluster Details

The cluster details page has these tabs:

Tab	Purpose
Details	Shows general cluster information and database details.
Nodes	Lists nodes attached to the cluster and provides node actions.
Database Backup	Shows existing backups, backup creation options, and restore history.
History	Shows manual changes made to the cluster.

Details Tab

Section	Fields
General Information	Cluster name, cluster description, number of nodes, created by, created at, status, and load balancer.
Database Details	DB version and replication type.

Cluster Actions

Use the action button in the top-right corner to edit:

• Business Group.
• Name.
• Description.

Managing Nodes

The Nodes tab provides:

• A table of nodes attached to the cluster.
• An option to add a replica node.
• An option to delete an existing node.
• A link to the node details page.

Click a node name to open its details page. The node details page is similar to a VM details page.

To add a replica, click Add Replica from the top-right corner.

To delete a node, open the three-dot menu in the node table row.

Managing Databases

[ADD CONTENT: No existing content in current documentation.]

Backup History

The Database Backup tab lists existing backups and provides backup creation options.

View Backups

Open the Database Backup tab to list existing backups in a table. The table includes details such as backup date, size, and type.

Create Periodic Backups

1. Click Manage Backups.
2. Select Periodic Backup.
3. Enter the required backup details.
4. Select a backup regime.
5. Save the configuration.

Field	Description
Buckets	Target bucket for backups.
Access Key ID	Access key ID used for backup access.
Access Key Secret	Access key secret used for backup access.
Backup Regime	Disable Backup, Daily Backup, Weekly Backup, or Monthly Backup.

Selecting Daily Backup, Weekly Backup, or Monthly Backup enables the save action.

Run an On-Demand Backup

1. Click Manage Backups.
2. Select Backup Now.
3. Enter the bucket and access key details.
4. Click Submit.

History

The History tab shows manual changes made to the cluster.