This n8n workflow automates the process of backing up PostgreSQL database tables as CSV files to a GitHub repository on a daily schedule. It helps maintain regular backups of database tables, updating existing files if data changes, or creating new backup files if they don’t already exist. The workflow involves scheduling, fetching table data, converting it to CSV, checking for existing backups, and uploading or updating files on GitHub. This setup is ideal for database administrators or developers seeking automated, versioned backups of their PostgreSQL data in a collaborative cloud repository.
Automated PostgreSQL Backup to GitHub
Node Count | 11 – 20 Nodes |
---|---|
Nodes Used | code, convertToFile, github, if, itemLists, postgres, scheduleTrigger, splitInBatches, stickyNote |
Reviews
There are no reviews yet.