Kann ich mehrmals täglich ein Backup machen, und sind diese sicher, wenn der Server ausfällt?

He’s saying that in ten years of running hundreds of forums he’s never wished he had more frequent backups.

If your data is very valuable then you can configure postgres to replicate to another server so that you can switch to a hot backup and lose no it very little data. You can Google “postgres replication”. I would guess it would take you a day or two to set up and another few days to make sure that you really understand how to switch to the backup server.

You could also make a cron job that would run the backup every ten minutes and have those backups in s3.

The recommendation, though, is to find something else to worry about.

1 „Gefällt mir“