Set Up a Cluster

Creating a Cluster

1. To create a Postgres cluster, go to Menu > Databases.

2. In the Databases tab, click + Add in the Postgres Clusters section to create a new Postgres Cluster.

3. Provide an appropriate Display Name.

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 from the list of cluster backups in the dropdown.

  • Select the Recovery Target Time field. A modal will open up.

    • Select the recovery date from the calendar.

    • Then, select the recovery time using the clock.

5. Choose 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.

6. 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.

The Database Manager lets you complete the Postgres Cluster setup from the DCD

7. In the Cluster to Datacenter Connection section, provide the following information:

  • Data Center: Select a datacenter from the available list.

  • LAN: Select a LAN for your datacenter.

  • Private IP/Subnet: Enter the private IP or subnet using the available Private IPs.

  • Once done, click the Add Connection option to establish your cluster to datacenter connection.

8. Select the appropriate Postgres Version. IONOS Database Manager supports versions 11, 12, 13, 14, and 15.

9. Enter the number of Postgres Instances in the cluster. One Postgres instance always manages the data of exactly one database cluster.

10. Select the mode of replication in the Synchronization Mode field; asynchronous mode is selected by default. The following are the available replication modes:

  • Asynchronous mode: 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 mode: 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.

Enter the values for creating the Postgres Cluster

11. Provide the initial values for the following:

  • CPU Cores: Select the number of CPU cores using the slider or choose from the available shortcut values.

  • RAM Size: Select the RAM size using the slider or choose from the available shortcut values.

  • Storage Type: SSD Premium is set by default.

  • Storage Size: Enter the size value in Gigabytes.

    The Estimated price will be displayed based on the input. The estimated cost is exclusive, where certain variables like traffic and backup are not considered.

Enter the values for creating the Postgres Cluster

12. Provide the Database User Credentials, such as a suitable username and an associated password.

13. In the Maintenance Window section, you can set a Maintenance time using the pre-defined format (hh:mm:ss) or the clock. Select a Maintenance day from the dropdown list. The maintenance occurs in a 4-hour-long window. So, adjust the time accordingly.

14. Click Save to create the Postgres Cluster.

Enter and save the values for creating the Postgres Cluster

Your Postgres Cluster is now created.

Last updated

Was this helpful?

Revision created

fixed broken links