Is it a hard thing to migrate local xtdb storage later to managed postgres? (in digitalocean now… saw the light, for the moment, regarding aws)
I don't think there's any off-the-shelf code for it, but if you're not concerned about preserving the documents' history it's really easy: just do (xt/q db {:find [(pull doc [*])], :where [doc :xt/id]}), save to an edn file (or serialize it with nippy if there are a lot of documents), then pass them to submit-tx in batches of 1000.
If you do want to preserve history, you can use xt/open-tx-log and iterate through that; it's just a little more complicated. e.g. there's some extra work you have to do to get the IDs for deleted documents.
👍