{"repo":"jacksonkasi0/postgres-r2-backup","free":true,"listed":false,"github":"https://github.com/jacksonkasi0/postgres-r2-backup","clone":"git clone https://github.com/jacksonkasi0/postgres-r2-backup.git","description":"An automated PostgreSQL backup and restore system with 30-day retention, Cloudflare R2 integration, and Docker support.","language":"TypeScript","stars":26,"topics":["automation","backup","cloudflare-r2","cron","database-backup","database-management","deno","docker","postgresql","restore"],"license":null,"category":"databases-storage","readme_excerpt":"PostgreSQL DB Backup & Restore via Docker & Deno This project provides a system to automate the backup and restore of a PostgreSQL database using Deno , Docker , and Cloudflare R2 . It supports local backups, restoring from local files, and restoring directly from Cloudflare R2. --- Technologies Used - Deno : Runtime for the scripts and automation. - Docker : Containerization for portable backup/restore workflows. - PostgreSQL : Database used for backups and restores. - PostgreSQL 16 Client : Installed in the container for backup and restore operations. (Note: Update the postgresql -client version in the Dockerfile if your database uses a different version.) - Cloudflare R2 : Object storage for storing backup files. - Winston : Logging library for structured and color-coded logs. - pg restore : PostgreSQL's native tool for restoring database dumps. - Cronie : Lightweight cron daemon for scheduling backup and restore tasks in the container. Getting Started Requirements 1. Deno installed (Install Guide). 2. Docker installed (Install Guide). 3. A .env file in the root directory containing: 4. Cloudflare R2 storage setup with appropriate access credentials. --- Available Tasks Backup Task Creates a backup of the database and uploads it to Cloudflare R2. Command: Process: 1. Generates a backup file in the local db backups/ directory. 2. Uploads the backup to the specified Cloudflare R2 bucket. --- Restore Task Restores the database from a local backup file. Command: Process: 1. Re","default_branch":null,"files":null,"tree":[],"storefront":"/r/jacksonkasi0","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/jacksonkasi0/postgres-r2-backup/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}