The latest articles on DEV Community by Kenny Chen (@kennychenfight). https://dev.to/kennychenfight https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F1142313%2F16e2a5c3-72f3-4655-98bb-e6b173d825d5.png https://dev.to/kennychenfight en Kenny Chen Sun, 20 Aug 2023 08:47:07 +0000 https://dev.to/kennychenfight/how-we-achieved-minimal-downtime-during-our-postgresql-database-upgrade-aia https://dev.to/kennychenfight/how-we-achieved-minimal-downtime-during-our-postgresql-database-upgrade-aia <p>Hello everyone, I’m Kenny, a Backend Engineer from <a href="https://about.dcard.tw/">Dcard</a>.</p> <p>Recently, we upgraded the primary PG 9.6 Cluster of Dcard’s services to the 11 version, managing to limit write downtime within ten minutes, and successfully rebuilt the OfflineDB and CDC services within an hour. In this <a href="https://blog.kennycoder.io/2023/08/19/How-We-Achieved-Minimal-Downtime-During-Our-PostgreSQL-Database-Upgrade-English-version/">article</a>, we will share how we accomplished this challenging task.</p> <p>Because English is not my native language, the grammar and semantics of the article might not be entirely accurate. However, while undergoing the upgrade, I also reviewed numerous upgrade articles from international companies and personal blog. As a result, I'd like to share my own upgrade experience. :)</p> <p>Feel free to ask me any question !</p> postgres database