Zero downtime db -database- migrations and safe operations in postgresql

zero_downtime_db_mirations.md

1. Safe Operations For High Volume PostgreSQL: https://www.braintreepayments.com/blog/safe-operations-for-high-volume-postgresql

2. • https://medium.com/paypal-tech/postgresql-at-scale-database-schema-changes-without-downtime-20d3749ed680
   • https://gist.github.com/jcoleman/1e6ad1bf8de454c166da94b67537758b

3. Zero downtime database migrations: https://www.rainforestqa.com/blog/2014-06-27-zero-downtime-database-migrations

4. Online migrations at scale: https://stripe.com/blog/online-migrations

5. Rails migrations, zero downtime: https://blog.codeship.com/rails-migrations-zero-downtime

6. Zero-downtime schema migrations in Postgres using views: https://fabianlindfors.se/blog/schema-migrations-in-postgres/ A tool(Reshape) that uses views to do zero-downtime migrations: https://fabianlindfors.se/blog/schema-migrations-in-postgres-using-reshape/

7. Stop traffic to DB, queue the transactions, run a PostgreSQL update, re-enable transactions: https://www.adyen.com/blog/updating-a-50-terabyte-postgresql-database

8. Safe and unsafe operations for high volume PostgreSQL: https://leopard.in.ua/2016/09/20/safe-and-unsafe-operations-postgresql#.YnRqzbdRX_E

9. Changing Tires at 100mph: A Guide to Zero Downtime Migrations: https://kiranrao.ca/2022/05/04/zero-downtime-migrations.html

10. Safely rename postgres table: https://brandur.org/fragments/postgres-table-rename

11. Tool that makes postgres zero-downtime migrations easy: https://github.com/xataio/pgroll

12. Zero downtime postgres version upgrade: https://www.instantdb.com/essays/pg_upgrade

13. state machine in postgres: https://felixge.de/2017/07/27/implementing-state-machines-in-postgresql/