Hi, author here: please do have a look on the first part, in which I give a bit more context on some decisions I had to go through https://brunoluiz.net/blog/2022/nov/low-downtime-postgres-up...

Observe that we only went with the approach of cloning and doing some "hacky" stuff with the replication because our database was quite large. Small ones might be okay with only using the logical replication + COPY.

The method described might be applicable to other managed Postgres, but I haven't tried it out.