Not sure how I can. You don't give any info. What OS are you on? What have you tried? What directions are you following? You say you installed PostGis 2.2.0 ... how? You say you "tried upgrade" ... how exactly? Why are you going to 2.2.0 when 2.2.2 is out?
Did you google the error message: "postgis.backend' is already set and cannot be changed until you reconnect". Because the very first hit is a trac ticket about it. Did you read that? -Andy On 07/28/2016 03:29 PM, Karthick Thanigaimani wrote:
Hi All, could anyone please help on this. thank you. regards, karthick ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ *From:* Karthick Thanigaimani <[email protected]> *To:* PostGIS Users Discussion <[email protected]> *Sent:* Wednesday, 27 July 2016 4:23 PM *Subject:* Re: [postgis-users] Help with PostGIS upgrade hi Andy / All, Thanks for the help I installed postGIS 2.2.0 in the Postgresql 9.3.8 and tried upgrade. It just waits for ages and nothing happens except for the below message. alter extension postgis update to '2.2.0'; WARNING: 'postgis.backend' is already set and cannot be changed until you reconnect CONTEXT: SQL statement "SELECT postgis_lib_version()" PL/pgSQL function postgis_major_version_check() line 21 at SQL statement is it because of any issues with libraries or a bug? Regards, Karthick ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ *From:* Pierre Bails <[email protected]> *To:* PostGIS Users Discussion <[email protected]> *Sent:* Tuesday, 26 July 2016 6:05 PM *Subject:* Re: [postgis-users] Help with PostGIS upgrade Hi, This works for us on Debian Jessie. It should also work on Ubuntu. # install laster version of postgres & postgis $ sudo apt-get install postgresql-9.5 postgresql-9.5-postgis-2.2 postgresql-9.5-postgis-2.2-scripts postgresql-client-9.5 postgresql-contrib-9.5 # stop and drop the cluster 9.5 (if exists) $ sudo pg_dropcluster 9.5 main --stop # Upgrade the 9.3 cluster to the latest version. (very long, depending of datasize) $ sudo pg_upgradecluster 9.3 main # check the cluster list $ pg_lsclusters Ver Cluster Port Status Owner Data directory Log file 9.3 main 5433 down postgres /var/lib/postgresql/9.3/main /var/log/postgresql/postgresql-9.3-main.log 9.5 main 5432 online postgres /var/lib/postgresql/9.5/main /var/log/postgresql/postgresql-9.5-main.log # after works fine, drop the old cluster $ sudo pg_dropcluster 9.3 main # then, remove old packages Good luke ! Pierre Le lun. 25 juil. 2016 à 23:37, Andy Colson <[email protected] <mailto:[email protected]>> a écrit : On 7/25/2016 3:49 PM, Karthick Thanigaimani wrote: > Hi, > > > > 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. > I installed the postGIS 2.2.2 libraries and tried updating the version > 2.2.2 but it says there is no upgrade path. > and when we run the pg_upgrade compatibility check it says postGIS has > to be upgraded. > > > Is there anyway to achieve the upgrade without doing pg_dump of the > schemas.? > > Please can anyone help. > > thank you. > > Regards, > Karthick I just did this actually. I first upgraded my PG9.3 to Postgis 2.2.2, then I used pg_upgrade to go from 9.3 to 9.5, which worked fine. Sounds like you had problems in PG9.3 upgrading Postgis. That should work ok. Really, though, if should not matter which you upgrade first. Can you install PostGIS 2.1.2 into PG 9.5? If so, do that and upgrade PG first. It should work ok. -Andy _______________________________________________ postgis-users mailing list [email protected] <mailto:[email protected]> http://lists.osgeo.org/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] <mailto:[email protected]> http://lists.osgeo.org/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/postgis-users
