The first time I upgraded a PostgresSQL database
Upgrading a live PostgreSQL database in a Kubernetes environment can be a daunting task. Earlier this year, I faced this exact challenge: migrating an important PostgreSQL 15 database to version 16. As this was the first time I tackled an upgrade of this nature, I realized I would gain more from the experience by documenting it. Additionally, I hope to share insights that might help others navigate similar upgrades. Context: The database was a live instance running in our Kubernetes cloud, serving as a template for other environments. It was operating on PostgreSQL 15, and we needed to upgrade it to version 16. To accomplish this, I had to deepen my knowledge of both PostgreSQL and Kubernetes. Fortunately, I collaborated with a knowledgeable colleague who was already well-versed in these areas. His support was invaluable—thanks Robin! ...