Not sure what DO managed PostgreSQL supports, but PostgreSQL streaming replication would seem like the natural way to go.

They don't support that, forgot to clarify that in my comment. Thanks!

And this is exactly why you do not want to use managed services with all sorts of restrictions that by the unlikeliest of coincidences also lock you in like a roach motel /s