Case Study: a software provider for insurance carriers upgrades PostgreSQL and PostGIS with Ispirer Systems

a software provider for insurance carriers upgrades PostgreSQL and PostGIS in 2.5 months with Ispirer Systems

The customer, a software provider for insurance carriers, faced a significant challenge when the impending end of support for PostgreSQL 11 threatened its critical databases. Their internal development team lacked the experience to handle the complex upgrade, particularly with the PostGIS extension, across 15 databases totaling 30 TB. To overcome this, they engaged Ispirer Systems and its system upgrade service to perform the migration on short notice.

Ispirer Systems executed a meticulous two-phase plan, beginning with a Proof of Technology to develop a reliable migration strategy. During the upgrade, the Ispirer team not only successfully migrated the systems to PostgreSQL 14 and PostGIS 3 but also implemented key infrastructure optimizations, such as switching disk and instance types. These efforts resulted in enhanced performance and reduced software maintenance costs for the customer. The entire project, which future-proofed their databases, was completed by Ispirer in just 2.5 months.