Discussion: Workaround for Gitaly Cluster Snapshot Limitation
Due to the known limitations related to snapshotting for disaster recovery impacting Gitaly Cluster, there is not a straightforward way to perform backups. The current recommendation is to perform a full GitLab backup however this is very time consuming for large GitLab SM deployments.
As a workaround, would it be possible to do a pg_dump of praefect_production db? This would allow users to schedule a recurring backup, via a script, of the Praefect DB which could be restored using pg_restore if needed. This could be accomplished via something like:
pg_dump -U praefect -W <password> -f my_backup.sql praefect_production
Any other potential workarounds are also acceptable. Let's use this issue to discuss this proposal and any others which may work.