5 ms·
What we did at Heroku as well as at Citus is rolled our own using the WAL logs. We run WAL-E for all clusters and for a PITR we have the ability to restore a b
by craigkerstiens 10y ago
What we did at Heroku as well as at Citus is rolled our own using the WAL logs.
We run WAL-E for all clusters and for a PITR we have the ability to restore a base backup then replay the WAL to a specific point. If this happens extremely rarely then doing this manually might absolutely work for you. For a case where it happens more frequently putting in more automation around it can absolutely make sense.