Restores

Restoring a Postgres backup

You can restore using:

• The HM console
• The API
• The CLI

Restoring using the HM console

1. Select the Backups tab to view existing backup that you can restore from.
2. Choose a backup to restore from.
3. Choose a cluster type to restore to.
4. Optionally, configure the restore:
   • In Cluster Settings, provide a unique name for the restored cluster.
   • For Restore Type, choose Fully Restore or Point In Time Restore. If you choose Point In Time Restore, use the date picker to select a point in time to restore to.
   • For DB Configuration and Additional Settings, select your preferred database configuration.
5. Select Restore Cluster. The restored cluster will appear in the Clusters list in the console.

Restoring using the API

To restore using the API, you need:

• A JSON file to specify the restore configuration.
• A shell script that uses curl to call the JSON file.

To restore to a point in time using the API:

1. In your JSON file, supply the following parameters:

   projectID: Obtain the projectID from the URL of your cluster. For example, if the URL is https:\//portal/projects/prj_6EOsaHpfS8RLshWH/clusters, the projectID is prj_6EOsaHpfS8RLshWH.

   source_cluster_id: Get the source_cluster_id from the URL of your cluster. For example, if the URL is https:\//portal/projects/prj_6EOsaHpfS8RLshWH/clusters/p-nubw4gnbv9>, the source_cluster_id is p-nubw4gnbv9.

   point_in_time: Provide a timestamp value for the point in time that you want to restore the cluster to.

   Supply additional information for the other configuration parameters as appropriate for the cluster you want to restore. For example:

   

2. Create a shell script to call the JSON file. For example:

3. Execute the shell script. If the script returns a clusterID as output, the restored cluster will appear in the Clusters list in the console. For example:

Restoring using the CLI

You can restore to a point in time using the CLI. To restore with the CLI, you need:

• A YAML file to specify the restore configuration.
• To use edbctl at the CLI to call the YAML file.

1. In your YAML file, supply the following parameters:

   

   Tip

   For more information on the parameters you can use with the restore command, use edbctl cluster restore -h in the CLI to view the help file.

2. Execute the CLI command by pointing it to your YAML file. A message is returned to indicate the cluster restore started. For example: