Upgrading PostgreSQL and PostGIS from 9.1 to 12.20 with Legacy Extension Support
Upgrading PostgreSQL and PostGIS Recently we did an upgrade of the legacy PostgreSQL 9.1 database of 1 TB size with PostGIS 1.5 version to PostgreSQL 12 version with PostGIS version 3.4.2. Upgrading a PostgreSQL database along with its PostGIS extensions can be a daunting task, especially when dealing with legacy versions. In this guide, I …