Postgres: automated Backup and Restore with Docker and Cron

Let's automate backing up and restoring the PostgreSQL database!

Here is what we will do:
* Prepare a Droplet (Virtual Machine) on DigitalOcean, using simple Python script
* Deploy a dockerized Postgres database, and then generate 2 million rows of data
* Deploy a dockerized db-backup-job, scheduled as a Cron Job, to create backups automatically; they will be saved both in the local file system as well as in the DigitalOcean's Spaces (similar to AWS S3), for extra redundancy

Of course, there is more in the video, so let's go!

P.S. I use DigitalOcean because of its simplicity - highly recommended :)

#database #postgresql #devops