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 modify the values, follow these steps:
Log in to DCD with your username and password.
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: — BUSY: When the cluster is being created or updated. For example, after creation, modifying its details or after restoration. — AVAILABLE: When the cluster is available and healthy. — 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.
You can view the details of a specific cluster. To do so, follow these steps:
Log in to DCD with your username and password.
Go to Menu > Databases > PostgreSQL. A list of all PostgreSQL clusters is displayed.
Select a cluster from the list by clicking on its name. Alternatively, click Details in the OPTIONS column.
Result: You can copy the cluster's Cluster UUID and DNS Name from the Cluster details tab. Additionally, you can also do the following: — Modify cluster details — Clone a cluster — Delete a cluster — Restore backups — View cluster metrics
Prerequisites: Prior to setting up a database, please make sure you are working within a provisioned VDC that contains at least one virtual machine from which to access the database. The VM you create is counted against the quota allocated in your contract.
Note: Database Manager is available only for contract administrators, owners, and users with Access and manage DBaaS privilege. You can set the privilege via the DCD group privileges.
To create a Postgres cluster, follow these steps:
1. Log in to the DCD, go to Menu > Databases > PostgreSQL.
Info: The Resource allocation section displays the resources allotted to your contract and the number of used and unused resources if you have already created PostgreSQL clusters.
2. In the PostgreSQL cluster overview window, click Create cluster to create a new Postgres cluster.
3. Specify the following:
Provide an appropriate Cluster Name.
Select a Location where your data for the database cluster will be stored. You can select an available datacenter within the cluster's data directory to create your cluster.
4. To create a Postgres Cluster from the available backups directly, you can go to the Create from backup section and follow these steps:
Select a Backup cluster from the drop-down list of cluster backups.
Click the Calendar icon in the Recover target time field to select a date and time:
Select the recovery date from the calendar.
Select the recovery time using the clock.
5. To configure your Cluster, enter the following details in the Cluster configuration section:
a. Select the appropriate PostgreSQL Version. IONOS Database Manager supports versions 12, 13, 14, and 15.
b. Enter the number of Instances in the cluster. One PostgreSQL instance always manages the data of exactly one database cluster. You can create a maximum of five instances within a cluster.
Note: Here, you will have a primary node and one or more standby nodes that run a copy of the active database, so you have n-1 standby instances in the cluster.
c. Select the mode of replication in the Synchronization mode field; Asynchronous mode is selected by default. The following are the available replication modes:
Asynchronous: In asynchronous mode, the primary PostgreSQL instance does not wait for a replica to indicate that it wrote the data. The cluster can lose some committed transactions to ensure availability.
Synchronous: Synchronous replication allows the primary node to be run standalone. The primary PostgreSQL instance will wait for any or all replicas. So, no transactions are lost during failover.
Strictly Synchronous: It is similar to the synchronous mode but requires two operating nodes.
d. Select a Backup Location that is explicitly your backup location (region). You can have off-site backups by using a region that is not included in your database region.
6. Specify the following in the Instance configuration section:
Number of CPUs (per instance): Select the number of CPU cores using the slider or choose from the available shortcut values.
RAM Size (per instance): Select the RAM size using the slider or choose from the available shortcut values.
Storage Type: Select a storage type for your instance. HDD is set by default.
Storage Size: Enter the storage size value in Gigabytes.
7. In the Network configuration section, provide the following information to connect your cluster with the datacenter:
Datacenter: Select a datacenter from the available list.
Datacenter LAN: Select a LAN for your datacenter.
Private IP: Select a private IP address from the drop-down list. For more information, see Private IP Address Ranges.
Note: To know your private IP address/Subnet, you need to:
Create a single server connected to an empty private LAN and check the IP assigned to that NIC in that LAN. The DHCP in that LAN always uses a /24 subnet, so you must reuse the first 3 octets to reach your database.
To prevent a collision with the DHCP IP range, it is recommended to use IP addresses ending between x.x.x.3/24 and x.x.x.10/24 (which are never assigned by DHCP).
If you have disabled DHCP on your private LAN, you must discover the IP address on your own.
8. In the Maintenance period (optional) section, you can set a maintenance day and time using the pre-defined format (hh:mm:ss) or the clock.
Select a Day from the drop-down list.
Note: We recommend choosing the day and time appropriately because the maintenance occurs in a 4-hour-long window.
9. Provide the following details in the User Creation section:
Username: Enter a username to provide access to the Postgres Cluster for the respective user.
Password: Enter a password for the respective user.
Note: The credentials will be overwritten if the user already exists in the backup.
Result: The Estimated costs will be displayed based on the input. It is exclusive and certain variables like traffic and backup are not considered.
10. Click Save to create the Postgres Cluster.
Result: Your Postgres Cluster is now created.
To view cluster metrics in DCD, follow these steps:
Log in to the DCD, go to Menu > Databases > PostgreSQL.
Select a cluster by clicking on its name or select Details from the OPTIONS column.
Select Cluster metrics to view the metrics. You can choose a time frame to view metrics for the respective instance.
Enter a Start Time (UTC) using the pre-defined format (hh:mm:ss) to schedule the maintenance task. You can also click the icon to set a time.
With IONOS DBaaS, you may roll back your PostgreSQL clusters to a previous point in time or use it to create a new cluster. This reliable function prevents data loss and downtime in unexpected situations.
For example, consider that certain values were accidentally deleted from your cluster around 11 hours today. The easiest way to recover missing data is to restore a backup before 11 hours.
Note: You can restore only one backup at a time, and you must wait for the restoration process to finish before restoring another backup.
Prerequisites:
The backup must belong to the PostgreSQL cluster to be restored.
The cluster must be in the AVAILABLE state.
To restore a cluster, follow these steps:
Log in to the DCD with your username and password.
Go to Menu > Databases > PostgreSQL.
Select a cluster from the list by clicking on its name. Alternatively, click Details in the OPTIONS column.
Select Backups to view the list of backups. Point In Time Recovery displays the earliest backup available for restoration. Select Restore backup for backup restoration.
a. In the Restore backup pop-up window, click within the text box to open the Calendar.
b. Backups are available only for those dates that are available for selection. Select a date and click Ok.
c. Select the Clock icon to set a time for restoring the appropriate backup from the chosen day. Click Ok to confirm your selection.
d. Select Restore to proceed with the restoration.
e. Select Restore to confirm the restoration.
Result: You will receive a confirmation that the cluster will be restored, and the respective cluster's STATE is set to Busy.
To create a new PostgreSQL cluster by cloning an existing one, follow these steps:
Log in to the DCD with your username and password.
Go to Menu > Databases > PostgreSQL. A list of all PostgreSQL clusters is displayed.
Select a cluster from the list by clicking on its name. Alternatively, click Details in the OPTIONS column.
The Cluster details tab displays the necessary information of the chosen cluster. Select Clone.
Verify the details of the chosen cluster in the Clone window.
Select Save to clone.
Result: The cloned cluster is created with the following name format: name-of-the-original-cluster-clone, if you do not specify a name of your choice. Its STATE is Busy while the cloning process is still in progress.
To delete a PostgreSQL cluster, follow these steps:
Log in to the DCD with your username and password.
Go to Menu > Databases > PostgreSQL. A list of all PostgreSQL clusters is displayed.
Click in the OPTIONS column and select Delete.
Alternatively, you can also delete a cluster using the following options:
Select a PostgreSQL cluster by clicking on its name and in the Cluster details tab, select Delete.
Select a PostgreSQL cluster by clicking on its name and in the Cluster details tab, select Edit. In the Edit window, select Delete cluster.
Select Delete in the dialog box to confirm deletion.
Result: The STATE of the respective PostgreSQL cluster is set to DESTROYING before it is completely deleted.
The Cluster details tab displays the necessary information of the chosen cluster. For more information, see .
After creation, you can modify the name, properties, configuration details, and the maintenance period of a PostgreSQL Cluster.
To restore a cluster, follow these steps:
Log in to the DCD with your username and password.
Go to Menu > Databases > PostgreSQL.
Click Edit in the OPTIONS column.
a. Alternatively, you can select a cluster from the list by clicking on its name or by selecting Details in the OPTIONS column.
b. Select Edit in the Cluster details tab.
The Edit window displays the details of the cluster. You can edit the following:
Properties: Modify the name of the cluster.
Cluster configuration: Update the PostgreSQL version and the number of instances.
Instance configuration: Modify the number of CPUs utilized, RAM size, or the storage.
Network configuration: Displays the name of the data center, the associated LAN, and the dedicated private IP address.
Maintenance period (optional): Displays the stipulated day of the week and the time scheduled for the maintenance window.
Result: The STATE of the respective PostgreSQL cluster is set to Busy when the update process is in progress.
Delete cluster: Select to delete the respective cluster. For more information, see .
