These pitfalls are one reasons why I built Reshape [0], which aims to automate zero-downtime schema migrations.
I can’t say it avoids all of them but we are working on a new product that would. If you are interested in this space (and Postgres specifically), I’d love to hear from you: [email protected]
Unfortunately not as Cockroach doesn't support triggers, which is what powers Reshape. We are looking into how to widen support though for our next product, reach out to [email protected] if you'd be interested in something like that!
I can’t say it avoids all of them but we are working on a new product that would. If you are interested in this space (and Postgres specifically), I’d love to hear from you: [email protected]
[0] https://github.com/fabianlindfors/reshape