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]> 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] > http://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/postgis-users
