How to Set Up Nightly Backups to AWS S3 for Multiple Neon Projects
Blog post from Neon
The article outlines a method for setting up automated nightly backups of multiple Neon Postgres databases to AWS S3 using GitHub Actions and the pg_dump/restore utility. It details the configuration of AWS, Postgres database connection strings, and GitHub Actions permissions necessary for the process. The approach involves configuring a single S3 bucket to store backup files in separate folders, each managed by an individual GitHub Action with its own schedule and retention period. The process includes installing PostgreSQL, configuring AWS credentials, setting file and folder variables, running the pg_dump command, and managing the retention of old files. The article emphasizes the importance of ensuring correct database URLs to avoid misplacing backups and advises on handling GitHub Actions timeouts by potentially using self-hosted runners.