Automatic and manual backups

Ensuring data safety is crucial for any database. RayDB provides both automatic and manual backup options to protect your PostgreSQL clusters from data loss.

Automatic Backups

RayDB automatically creates backups at regular intervals to ensure data recovery when needed.

Features of Automatic Backups

• Daily Backups: A full backup is taken once every 24 hours.
• Retention Policy: Backups are retained for a defined period (e.g., 7 or 30 days, depending on the plan).
• Point-in-Time Recovery (PITR): Enables restoration to a specific moment within the retention window.
• High Availability Clusters: Business plans ensure that backups are distributed across multiple locations for redundancy.

Restoring from Automatic Backups

To restore from an automatic backup:

1. Log in to the RayDB Dashboard.
2. Navigate to the Clusters section and select the cluster to restore.
3. Go to the Backups tab.
4. Choose the backup timestamp and click Restore.

Manual Backups

For additional flexibility, RayDB allows users to trigger manual backups at any time.

Creating a Manual Backup

1. Log in to the RayDB Dashboard.
2. Navigate to the Clusters section and select the cluster.
3. Open the Backups tab.
4. Click Create Backup to generate a snapshot of your database.

Downloading a Backup

Users can download manual backups for external storage or migration purposes.

1. Go to the Backups tab.
2. Locate the backup and click Download.

Best Practices

• Schedule Regular Backups: Even with automatic backups, manual backups before major updates ensure additional safety.
• Test Restores: Regularly test backups by restoring them to a staging environment.
• Store External Copies: For regulatory compliance, download critical backups to an external location.

For details on restoring backups, refer to Restoring from a Backup.