PostgreSQL S3 backups

a year ago

Description: A simple NodeJS app to back up your PostgreSQL database to S3 via a cron.

Category: Automation

URL: https://railway.app/template/I4zGrH

10 Replies

10 months ago

Would it be possible to integrate add a FORCE_PATH_STYLE variable that would config aws-sdk and set s3ForcePathStyle to true, allowing compatibility with non-aws buckets by not automatically attempting to append the bucket name to the start of the endpoint url?

https://stackoverflow.com/questions/64969756/how-to-prevent-aws-sdk-from-setting-bucket-as-subdomain-for-an-ip-address-as-end#:~:text=AWS.config.s3ForcePathStyle%20%3D%20true%3B


Status changed to Awaiting Railway Response railway[bot] 10 months ago


10 months ago

Made the suggested changes, please try deploying this branch - https://github.com/railwayapp-templates/postgres-s3-backups/tree/force-path-style-option


10 months ago

Worked! Thank you so much!


Status changed to Awaiting Railway Response railway[bot] 10 months ago


10 months ago

This PR has now been merged!


anthonyjamez12HOBBY

8 months ago

Is this a full backup, incremental backup, or differential backup?


tim2PRO

8 months ago

What is the recommended method to restore the DB to a backup (in S3)?


8 months ago

Anthony, terribly sorry for missing your reply, it is a full backup.

Tim, you would want to download the backup from your bucket and use pg_restore.


anthonyjamez12HOBBY

8 months ago

Your good! Thank you for the information.


rdilrubaHOBBY

18 days ago

Hey! I cannot connect to db with db url and get message;
postgres.railway.internal:5432 - no response


rdilruba

Hey! I cannot connect to db with db url and get message;postgres.railway.internal:5432 - no response

17 days ago

Please open your own thread as this error would not be specific to the template.


PostgreSQL S3 backups - Railway Help Station