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.
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.