All Templates / Automation
PostgreSQL S3 backups
A simple NodeJS app to back up your PostgreSQL database to S3 via a cron.
Backup CRON
railwayapp-templates/postgres-s3-backups
Just deployed
Overview
The template uses a basic cron job written in TypeScript to dump your PostgreSQL data to a file and then upload the file to S3.
Highlights
- Configurable backup schedule: By default, the cron runs at 5 AM everyday but is configurable via the
BACKUP_CRON_SCHEDULEenvironment variable. - Support for custom buckets: The script also supports using a
AWS_S3_ENDPOINTenvironment variable to use any S3 compliant storage bucket (eg: Wasabi).
Template Content
Backup CRON
railwayapp-templates/postgres-s3-backupsAWS_ACCESS_KEY_ID
The access key ID for the IAM user.
AWS_SECRET_ACCESS_KEY
The secret access key for the IAM user.
AWS_S3_BUCKET
The name of the S3 bucket.
AWS_S3_REGION
The region the S3 bucket is in.
BACKUP_DATABASE_URL
The database url for the database to backup. Set to ${{ Postgres.DATABASE_PRIVATE_URL }} if the database is in the same project. See reference variables.
Deploy Now
Details
Railway Templates
Created on Sep 1, 2022
638 total projects
252 active projects
100% success on recent deploys
TypeScript, Dockerfile
Automation
More templates in this category
