That's just a ... relay, right

You set your own private relay, and configure your client to publish to it (in addition to your other, usual relays). Viola, all posts backed up in your own database.