PostgreSQL

Create a Cluster

1. Click the 'add a new cluster' button and select PostgreSQL.

   
2. Fill the required information about the database cluster and click next.

   
3. Fill additional required information and click 'Check' to verify validity.

   
4. 'Rest API' Button will copy to clipboard for your DevOps tools.

   
5. Click 'Submit' to create the cluster.

Restore a node or cluster

1. Drag the selected backup onto the primary.

   
2. Click the correct option for your restoration point.

   
3. To avoid loss of data, type 'restore me' into the text box to confirm your decision.

   
4. 'Rest API' Button will copy to clipboard for your DevOps tools.

   
5. Click 'Submit' to initiate the restore.

Create a standby

1. Switch to the 'Standbys' tab on your cluster inventory.

   

2. Drag the object labeled 'Drag me on to Primary to create a standby' onto the primary

   
3. Fill in the required information for your standby node and click next.

   
4. Fill additional required information and verify settings' validity by clicking the 'Check' button.

   

5. 'Rest API' Button will copy to clipboard for your DevOps tools.

   

6. Click 'Submit' to create the Standby.

Create a database

1. Switch to the 'Databases' tab on your cluster inventory.

   
2. Drag the object labeled 'Drag me on to Primary to create a database' onto the primary.

   
3. Choose a name for your database and click the 'Check' button to ensure it is available.

   
4. You may opt into the auto-delete function, your database will be deleted at your desired date.

   
5. 'Rest API' Button will copy to clipboard for your DevOps tools.

   
6. Click 'Submit' to create the Database.

Start and stop a node

1. Double click the primary node to enter the node configuration.

   
2. To stop the node, click the 'Stop' button.

   
3. The instance status is shown on the left, a red star indicates the node is stopped.

   
4. To restart the node, click the 'Start' button.

   

Set node config and limits

1. Double click the primary node to enter the node configuration.

   
2. These are the current setting of your node.

   

3. Click the 'change' button to open the node settings.

   
4. Open the drop-down menu to modify your node.

   
5. 'Rest API' Button will copy to clipboard for your DevOps tools.

   
6. Click 'Submit' to confirm your changes.

Backup a node or a cluster

1. Switch to your 'backup' tab on your cluster inventory.

   
2. To create a backup, drag your primary node.onto your backups inventory.

   
3. Select your desired backup strategy, standard backup or schedule a routine backup.

   
4. Select a destination for your backup to be stored and whether or not you would like your backup to be compressed.

   
5. 'Rest API' Button will copy to clipboard for your DevOps tools.

   
6. Click 'Submit' to start your backup.

Backup a database

1. Click the 'Physical layout' switch to view the databases in the cluster.

   
2. Switch to your 'Import/Export' tab to view your database backup inventory.

   
3. Drag your desired database onto your database inventory.

   
4. Choose a name for your backup database, select additional options and click next.

   
5. 'Rest API' Button will copy to clipboard for your DevOps tools.

   
6. Click 'Submit' to start your backup.

Restore a database

1. Switch to your 'Import/Export' tab to view your database inventory.

   
2. Drag your desired backup onto your primary node.

   
3. Type 'restore me' into the text box to avoid accidental loss of data.

   
4. 'Rest API' Button will copy to clipboard for your DevOps tools.

   
5. Click 'Submit' to restore.

Drop a node

1. Drag the node you with to drop onto the bin, can be either primary or a standby.

   
2. Type 'drop me' into the text box to confirm your decision.

   
3. 'Rest API' Button will copy to clipboard for your DevOps tools.

   
4. Click 'Submit' to drop the node.

Drop a database

1. Click the 'Physical layout' switch to view the databases in the cluster.

   
2. Drag the database you wish to drop onto the bin.

   
3. Type 'drop me' into the text box to confirm your decision.

   
4. 'Rest API' Button will copy to clipboard for your DevOps tools.

   
5. Click 'Submit' to drop the database.

Drop a backup or export

1. Switch to your 'Import/Export' tab to view your database inventory.

   
2. Drag the export you wish to drop onto the bin.

   
3. 'Rest API' Button will copy to clipboard for your DevOps tools.

   
4. Click 'Yes' to drop the export.