Automates daily backups of all public Postgres tables to a GitHub repo as CSV files, updating existing files or creating new ones for changes.
This n8n workflow provides a robust, automated solution for backing up Postgres databases by exporting all tables from the public schema into CSV files stored in a GitHub repository. It runs every 24 hours via a schedule trigger, ensuring your data snapshots are always current without manual intervention. The process intelligently handles existing files by updating them if data changes or creating new ones for newly discovered tables, leveraging GitHub's version control for historical tracking.
Platform
n8n
Category
HR Management
Price
$17.99
Creator
Fred Garcia
postgres
backup
github
csv
database
automation
schedule
devops
data-engineering
storage
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.