Do daily backups cause downtime? read only? how long do they take?

(Tobias Eigen) #1

do the automated daily backups cause downtime? or does the site go into read only during backups? how long do the backups take to complete? Is there somewhere I can look to find out this information?

(Régis Hanol) #2

Backups never cause downtime. They only put your instance in read-only mode for a very small part of the backup process: when we’re creating a backup of the database using the pg_dump program.

It’s entirely related to the site of your Discourse instance. On our largest instances, it takes about 15 seconds for the pg_dump program to finish, but the whole backup process might take a couple of minutes (archiving several GB of uploads takes a while, even on high end SSDs ;))

You can either dig in the rails logs or launch a backup and look for the timestamps associated with the lines “Enabling readonly mode...” and “Disabling readonly mode...”.