Workflow: Periodic Database Backups

[lcox74]

To ensure the integrity and safety of our data within the newly integrated PostgreSQL database environment, there is a critical need to implement a systematic backup process. This would require some form of Github workflow specifically designed to manage periodic database backups by generating PostgreSQL dumps.

Requirements:

• Automated Backup Workflow: Develop a GitHub Actions workflow that periodically triggers a PostgreSQL dump on the deploy server. This automation should be configurable in terms of frequency (e.g., daily, weekly), ensuring regular backups without manual intervention.
• Backup Storage Strategy: While the primary task of this workflow is to create the database dumps, the strategy for storing these backups needs some form of consideration. Factors such as storage location, security, and access control are crucial and will be discussed and finalised in this issue's comments.