DB Drive Backups

Automated system for backing up PostgreSQL databases and storing them on Google Drive.

Features

• Automatically creates PostgreSQL database backups in custom format (.tar)
• Uploads backups to Google Drive
• Sends email notifications
• Manages backup retention (removes old backups)
• Preserves monthly backups for long-term storage
• Automatic crontab scheduling
• Supports selective table restoration

Requirements

• PostgreSQL
• rclone
• msmtp
• Google Drive account

Installation

1. Clone this repository:

   git clone https://github.com/ATERCATES/dbDriveBackups.git
   cd dbDriveBackups

2. Run the configuration script:

   ./configure.sh

3. Configure environment variables:

   cp .env.template .env
   nano .env  # Edit with your data

Usage

Run the backup script manually:

./backupdb.sh

Restoring Backups

The backups are created in PostgreSQL's custom format, which allows selective table restoration:

# Restore entire database
pg_restore -h hostname -U username -d database_name backup_file.tar

# List contents of backup
pg_restore -l backup_file.tar > backup_list.txt

# Restore specific tables (edit backup_list.txt to keep only desired tables)
pg_restore -L backup_list.txt -h hostname -U username -d database_name backup_file.tar

Scheduling Backups

When running the configuration script, you'll be asked if you want to set up automated backups with crontab. You can choose from several scheduling options:

• Daily backups (at a specific time)
• Weekly backups (Sunday)
• Monthly backups (1st day of the month)
• Custom schedule

Alternatively, you can manually configure it as a scheduled task with cron:

# Example: run every day at 2:00 AM
0 2 * * * cd /path/to/dbDriveBackups && ./backupdb.sh >> /path/to/dbDriveBackups/logs/cron.log 2>&1

Structure

dbDriveBackups/
├── .env.template    # Environment variables template
├── .env             # Environment variables file (not included in git)
├── backupdb.sh      # Main backup script
├── configure.sh     # Initial configuration script
├── logs/            # Log files directory
├── LICENSE          # Project license
└── README.md        # Documentation

License

This project is licensed under the terms of the MIT License. See the LICENSE file for details.