DEV Community

Cover image for πŸš€ Automate Your PostgreSQL Backups with Ease! 🐳
Jackson Kasi
Jackson Kasi Subscriber

Posted on

2 2 1 1 1

πŸš€ Automate Your PostgreSQL Backups with Ease! 🐳

Simplify your database management with a robust system for backup and restore using Deno, Docker, and Cloudflare R2. 🐳

✨ Key Features:

  • Automated Backups: Schedule via cron or run on-demand.
  • Seamless Restores: From local files or directly from R2.
  • Cloud Integration: Effortlessly upload and manage backups in Cloudflare R2.

πŸ”§ Get Started:

  1. Clone the repo: postgres-r2-backup.
  2. Set up your .env file with the required details.
  3. Run: deno task run:backup or deno task run:restore.

πŸ’‘ Extend It: Add any features you needβ€”like schema-specific restores or custom retention policies.

Start now and make database management hassle-free! πŸš€

Top comments (5)

Collapse
 
thesohailjafri profile image
Sohail SJ | TheZenLabs β€’

this could be done any other DBs right like mongo or mysql?

Collapse
 
jacksonkasi profile image
Jackson Kasi β€’

As of now, it supports only PostgreSQL.
Okay, let me work on adding support for MySQL and MongoDB soon. I’ll also provide an update. :)

I’ll add this to the to-do list:

To-Do List

Collapse
 
thesohailjafri profile image
Sohail SJ | TheZenLabs β€’

Watching the repo

Collapse
 
thesohailjafri profile image
Sohail SJ | TheZenLabs β€’

Staring the repo!

Collapse
 
jacksonkasi profile image
Jackson Kasi β€’

πŸ™Œ

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

πŸ‘‹ Kindness is contagious

Dive into an ocean of knowledge with this thought-provoking post, revered deeply within the supportive DEV Community. Developers of all levels are welcome to join and enhance our collective intelligence.

Saying a simple "thank you" can brighten someone's day. Share your gratitude in the comments below!

On DEV, sharing ideas eases our path and fortifies our community connections. Found this helpful? Sending a quick thanks to the author can be profoundly valued.

Okay