[postgis-users] Help with PostGIS upgrade

[Andy Colson]

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 <kargold100 at yahoo.com>
> *To:* PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> *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 <bails at getredbird.com>
> *To:* PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> *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 <andy at squeakycode.net <mailto:andy at squeakycode.net>> 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
>     postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
>     http://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
> http://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
>