[Arbortheus]

Offsite replica is only applicable if the cause is a failure of the primary. What if I’m restoring a backup because someone accidentally dropped the wrong table?

[nijave]

You can PITR on a replica which would be much faster than restoring a full backup of a large DB

[ants_everywhere]

I would hope dropping a table on a production database is something that is code reviewed

[anonymars]

Isn't the entirety of disaster recovery about situations that aren't supposed to happen?

High availability is different from disaster recovery

[benreesman]

nah, on a long enough timeline everything will go wrong. blaming the person who managed to drop the table finally is dumb: if you can't fix literally everything that could happen to it, it's not done.