PgDog reposted this
We recently upgraded our production Postgres database — and with zero downtime for our users. Our customer usage was scaling extremely fast, and we needed a way to upgrade our database instance with obstacles like zero data retention, no logical replication, and production scale connection loads. We wrote up a full technical blog with the tradeoffs, pseudo-code, and playbook needed to perform the same type of migration: https://lnkd.in/gh34Mh2C If solving problems like this sounds interesting, we’ve just opened a new role for a Founding Site Reliability Engineer: https://lnkd.in/gRJsC7FW Special thanks to the team at PgDog for the collaboration on this project, and Himanshu our DevOps engineer for his great work here!