<html><head></head><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:16px"><div id="yui_3_16_0_ym19_1_1469015041623_78525">Hi,<br></div><div class="qtdSeparateBR"><br><br></div><div class="yahoo_quoted" id="yui_3_16_0_ym19_1_1469015041623_78506" style="display: block;"><div style="font-family: Courier New, courier, monaco, monospace, sans-serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1469015041623_78505"><div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, Sans-Serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1469015041623_78504"><div class="y_msg_container" id="yui_3_16_0_ym19_1_1469015041623_78526"><div id="yiv5346024088"><div id="yui_3_16_0_ym19_1_1469015041623_78528"><div style="color:#000;background-color:#fff;font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:16px;" id="yui_3_16_0_ym19_1_1469015041623_78527"><div id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40474"><br></div><div id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40474" dir="ltr"><span style="color:rgb(51, 51, 51);font-family:Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif;font-size:13px;background-color:rgb(250, 250, 250);" id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40560">We have a database that is of ~1 TB and the schemas are big as well. We would like to upgrade the database version from PostgreSQL 9.3.x to 9.5.x and the DB has PostGIS 2.1.2 which also need to be updated to 2.2.2 as per version 9.5.x. </span><br style="color:rgb(51, 51, 51);font-family:Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif;font-size:13px;background-color:rgb(250, 250, 250);" id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40561"><span style="color:rgb(51, 51, 51);font-family:Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif;font-size:13px;background-color:rgb(250, 250, 250);" id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40562">I installed the postGIS 2.2.2 libraries and tried updating the version 2.2.2 but it says there is no upgrade path. </span><br style="color:rgb(51, 51, 51);font-family:Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif;font-size:13px;background-color:rgb(250, 250, 250);" id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40563"><span style="color:rgb(51, 51, 51);font-family:Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif;font-size:13px;background-color:rgb(250, 250, 250);" id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40564">and when we run the pg_upgrade compatibility check it says postGIS has to be upgraded.</span></div><div id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40474" dir="ltr"><br></div><div id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40474" dir="ltr"><br style="color:rgb(51, 51, 51);font-family:Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif;font-size:13px;background-color:rgb(250, 250, 250);" id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40565"><span style="color:rgb(51, 51, 51);font-family:Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif;font-size:13px;background-color:rgb(250, 250, 250);" id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40566">Is there anyway to achieve the upgrade without doing pg_dump of the schemas.? </span><br style="color:rgb(51, 51, 51);font-family:Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif;font-size:13px;background-color:rgb(250, 250, 250);" id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40567"><br style="color:rgb(51, 51, 51);font-family:Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif;font-size:13px;background-color:rgb(250, 250, 250);" id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40568"><span style="color:rgb(51, 51, 51);font-family:Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif;font-size:13px;background-color:rgb(250, 250, 250);" id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40569">Please advise.</span><br style="color:rgb(51, 51, 51);font-family:Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif;font-size:13px;background-color:rgb(250, 250, 250);" id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40570"><br style="color:rgb(51, 51, 51);font-family:Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif;font-size:13px;background-color:rgb(250, 250, 250);" id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40571"><span style="color:rgb(51, 51, 51);font-family:Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif;font-size:13px;background-color:rgb(250, 250, 250);" id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40572">Thanks,</span><br style="color:rgb(51, 51, 51);font-family:Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif;font-size:13px;background-color:rgb(250, 250, 250);" id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40573"><span style="color:rgb(51, 51, 51);font-family:Verdana, Arial, Tahoma, Calibri, Geneva, sans-serif;font-size:13px;background-color:rgb(250, 250, 250);" id="yiv5346024088yui_3_16_0_ym19_1_1469015041623_40574">Karthick</span><br></div></div></div></div><br><br></div> </div> </div> </div></div></body></html>