Our Journey to PostgreSQL 12

[salamhanghat]

In November 2020 we began a large migration to upgrade our PostgreSQL cluster from version 9.6 to 12.4. In this post I’ll give an overview of our architecture at Coffee Meets Bagel, walk through the steps we took to perform this upgrade with less than 30 minutes of cumulative downtime, and share some lessons learned along the way.

https://imperial.instructure.com/courses/15734/pages/50m2-season-1-...
https://imperial.instructure.com/courses/15734/pages/dead-pixels-se...
https://imperial.instructure.com/courses/15734/pages/dead-pixels-se...
https://imperial.instructure.com/courses/15734/pages/full-series-50...
https://imperial.instructure.com/courses/15734/pages/full-series-re...
https://imperial.instructure.com/courses/15734/pages/full-watch-50m...
https://imperial.instructure.com/courses/15734/pages/marcella-seaso...
https://imperial.instructure.com/courses/15734/pages/resident-alien...
https://imperial.instructure.com/courses/15734/pages/snowpiercer-se...
https://imperial.instructure.com/courses/15734/pages/watch-marcella...
https://imperial.instructure.com/courses/15734/pages/watch-resident...
https://sukotoro.cookpad-blog.jp/articles/566164
https://sukotoro.cookpad-blog.jp/articles/566165
https://sukotoro.cookpad-blog.jp/articles/566166
https://paiza.io/projects/iH6f1rnTGErvLDhE87QLHQ?language=php
https://onlinegdb.com/rWDkQRYLP
http://www.clashofclans-tools.com/Thread-40484/our-journey-to-postg...
http://www.shadowville.com/board/general-discussions/our-journey-to...
https://blog.goo.ne.jp/aldebaranff/e/c50c1ca474dfb8e7b73d00e3081a6da0
http://paste.jp/d63771ec/
https://paiza.io/projects/mpRKbS3m6BaNK4J7XysjTA?
https://www.hybrid-analysis.com/sample/795b01635804968cc9c8ddd59f37...
http://www.4mark.net/story/3121207/50m2-season-1-episode-1-online-f...