Infrastructure - Implement a PostgreSQL periodic backup for the general DB

Set up a scheduled PostgreSQL backup process for the general database. The process should create backups periodically (e.g., daily), store them securely, and implement rotation and retention to manage storage efficiently.

Example – Rotation & Retention:

• Frequency: Daily backups at 2:00 AM.
• Retention Policy: Keep daily backups for 7 days.
• Rotation Strategy: Automatically delete backups older than their retention period.