Skip to content

sotechho/pg-backup-script

Repository files navigation

Database Backup Script

Automated database backup system with local dump creation and cloud upload to DigitalOcean Spaces (S3-compatible storage).

Features

  • Supports PostgreSQL and MySQL databases
  • Automated backups via cron schedule
  • Upload to DigitalOcean Spaces
  • Redis-backed job queue for reliable processing

Quick Start

npm install
cp .env.example .env
# Edit .env with your configuration
npm run backup   # Start backup scheduler
npm run worker   # Start upload worker (in another terminal)

Requirements

  • Node.js 18+
  • PostgreSQL client (pg_dump) or MySQL client (mysqldump)
  • Redis server
  • DigitalOcean Spaces bucket

Documentation

See docs/guide.md for detailed usage instructions.

About

Automated PostgreSQL and MySQL database backup script with local dump creation and cloud upload to DigitalOcean Spaces (S3-compatible storage).

Topics

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors

Languages