Database backup strategy

NeetoDeploy provides comprehensive and rapid disaster recovery for crashes or data losses. We offer the following strategies to recover the data in the event of an incident:

Available Backup Strategies

There are two solutions to ensure data safety and continuous protection:

  1. Continuous backup

  2. Database exports and imports

Choosing the Correct Backup Strategy

CASE 1: Recovering from a database crash that happened within the last 24 hours

The continuous backup system allows for rollback to any point within the last 24 hours. Knowing that the crash occurred recently, you can restore your database to a state just before the crash. This process will create a new PostgreSQL instance with the desired data from that specific point in time.

CASE 2: Recovering from a database crash that happened before the last 24 hours

If the database crash occurred more than 24 hours ago, the continuous backup system won't be sufficient to recover the data. In this scenario, you can only use the exports and imports to recover the data. To ensure the availability of the backups it's crucial to have scheduled exports enabled. So it is a best practice to enable the scheduled backups right after creating a new PostgreSQL instance. You can download the necessary backup from the export section and restore it using the import feature.

Can't find what you're looking for?