Data loss protection is critical in modern database management. Learn how to create and manage automated backup strategies for your PostgreSQL database using the DynHyp platform.

What You'll Learn in This Guide:

How to create automated backup plans
Daily, Weekly, and Monthly backup options
Full backup management
Backup schedule configuration
How to download backup files

Creating Automated Backup Plan: Step-by-Step Guide

1. Accessing the Backup Tasks Module

Log in to DynHyp Dashboard
Click on "Backup Tasks" in the left menu
Click the "Create Backup Task" button in the top right corner

2. Backup Schedule Configuration

Basic Settings:

Schedule Name: Set a descriptive name for your backup plan (e.g., "Daily Database Backup")
Server: Select the PostgreSQL server to be backed up
Backup Type: Choose the Full backup option

Timing Settings:

Backup Frequency: Select from Daily, Weekly, or Monthly options
Retention Period: Determine how many backups to keep
Time: Select the time for backup execution (UTC)

Notification Settings:

Set Active/Inactive status
Enable/disable email notifications

3. Backup Management

Important Points:

Backups are automatically named with UTC timestamps
Backups are retained according to the specified retention period
Each backup is taken as a full backup
Backups start automatically at the scheduled time

4. Accessing and Downloading Backup Files

Click the three dots (⋮) menu of the relevant server on the Backup Tasks screen
Select "Backup Files"
Click the download button next to the desired backup to download

Backup Best Practices

1. Backup Strategy

Schedule daily backups for critical data
Set retention period based on data importance
Take backups at different time intervals
Keep email notifications active

2. Backup Management

Regularly check backups
Store downloaded backups securely
Take manual backup before important changes
Monitor backup logs

3. Important Tips

💡 Schedule backups during low-traffic hours
💡 Create multiple backup plans
💡 Optimize retention period based on disk space
💡 Backup critical data more frequently

Conclusion

You have now secured your PostgreSQL database with DynHyp's automated backup features. Regular backups and easily accessible backup files minimize the risk of data loss.