It sounds like litestream (https://litestream.io/) might be useful to you here