View PostgreSQL Clusters

After successfully configuring your PostgreSQL clusters, you can modify specific details, clone the cluster configuration, or delete a specific PostgreSQL cluster if it is no longer required.

To view the PostgreSQL details, follow these steps:

• In the DCD, go to Menu > Databases > PostgreSQL. A list of all PostgreSQL clusters is displayed.

Result: You can view the total number of resources allocated and the list of all clusters in addition to the following details:

• NAME: Displays the name of the cluster. Select the name of the cluster to view its details.
• STATE: Displays the state of the respective cluster:

  • PROVISIONING: When the cluster is being created.
  • AVAILABLE: When the cluster is available and running normally.
  • UPDATING: When the cluster is being updated. For example, after modifying its details or restoring from a backup.
  • DESTROYING: When the cluster is being deleted.
  • FAILED: An error occurred.
• LOCATION: Displays the location where the cluster is located.
• INSTANCES: Displays the number of instances.
• VERSION: The version selected during cluster creation.
• OPTIONS: Select to perform the following:

  • Details: Select to view the details of the respective cluster.
  • Edit: Select to edit the respective cluster.
  • Delete: Select to delete the corresponding cluster. In the dialog box that appears, select Delete to confirm deletion. For more information, see Delete a PostgreSQL Cluster.

List of PostgreSQL clusters

View individual Cluster details

You can view the details of a specific cluster. To do so, follow these steps:

1. In the DCD, go to Menu > Databases > PostgreSQL.

A list of all PostgreSQL clusters is displayed.

2. Select a cluster from the list by clicking on its name. Alternatively, click Details in the OPTIONS column.

Select a PostgreSQL cluster

Result: For the selected PostgreSQL cluster, you can view the following details:

• Properties:

  • State: The current state of the cluster.
  • Cluster UUID: The unique identifier of the cluster. Click Copy to copy it to the clipboard.
  • DNS Name: The DNS name used to connect to the cluster. Click Copy to copy it to the clipboard.
  • PostgreSQL Version: The PostgreSQL version selected during cluster creation.
  • Location: The location where the cluster is deployed.
• Cluster configuration:

  • Instances: The number of instances in the cluster.
  • Synchronization mode: The replication mode configured for the cluster.
  • Connection pooler: The connection pooler mode configured for the cluster.
  • Backup location: The region where cluster backups are stored.
  • Backup retention (days): The number of days backups are retained.
• Instance configuration:

  • Number of CPUs: The number of CPU cores allocated per instance.
  • RAM Size: The RAM allocated per instance.
  • Storage: The storage size allocated per instance.
• Network configuration:

  • Virtual Data Center: The datacenter selected for network configuration.
  • VDC LAN: Displays the LAN for the Virtual Data Center (VDC).
  • IP/Subnet: The private IP address and subnet used to connect to the cluster.
• Maintenance period (Optional):

  • Weekday: The day of the week scheduled for the maintenance window.
  • Start Time: The start time of the maintenance window in UTC.
• Observability:

  • Logs: Indicates whether log forwarding is allowed or not.
  • Metrics: Indicates whether metrics forwarding is allowed or not.
  • Grafana dashboard: You can open the metrics in Grafana. For more information, see Access Metrics from the Platform.
• Activity:

  • Created by: The user who created the cluster.
  • Created on: The date and time the cluster was created.
  • Last modified by: The user who last modified the cluster.
  • Last modified on: The date and time of the last modification.
  • Resource URN: The unique resource identifier of the cluster. Click Copy to copy it to the clipboard.
• Estimated costs:

  • Per hour: The estimated hourly cost for the cluster.
  • Per month: The estimated monthly cost for the cluster.

View details of a PostgreSQL cluster

Next steps

You can perform the following actions as well from the cluster details page:

• Edit: Modify cluster properties such as instances, resources, and maintenance settings.
• Clone: Create a copy of your cluster for testing or migration purposes.
• Delete: Permanently remove a cluster that is no longer required.
• Backups: Restore your cluster to a previous state using an available backup.