upgrade from PG12/Postgis3 to PG15/Postgis3 without pg_upgrade

4 votes

1 answer

196 views

                          What is a recommended way to upgrade a medium size (3.1Tb) production database from PG12/Postgis3 to PG15/Postgis3 with a reasonable (up to an hour) downtime?

pg_upgrade fails to perform the task with the following error: "old and new pg_controldata maximum TOAST chunk sizes are invalid or do not match".

Asked by user3159253 (143 rep)

Jun 19, 2025, 12:34 PM
Last activity: Jun 19, 2025, 01:58 PM

upgrade from PG12/Postgis3 to PG15/Postgis3 without pg_upgrade

Related Questions