In order to use some newer functions like ST_RemoveRepeatedPoints() (for geoshape optimizations`, we need version 2.2.0+. Our current version -- SELECT PostGIS_full_version();
POSTGIS="2.1.4 r12966" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.9.1" LIBJSON="UNKNOWN" RASTER
2.1.4 is over 2 years old - http://postgis.net/docs/release_notes.html#idm38514
postgis 2.3.0 is available in jessie backports. @Yurik the initial demand is to upgrade to postgis 2.2+, is 2.3.0 suitable as well?
Mentioned in SAL (#wikimedia-operations) [2016-10-10T17:20:49Z] <gehel> upgraded maps1* to postgis 2.3.0 - T144763
manual upgrade done on maps1* for testing purpose (there is no user traffic on maps1*)
Change 317494 had a related patch set uploaded (by Gehel):
postgis - upgrade to postgis 2.3
manual steps required after this upgrade:
This breaks labsdb1006 and labsdb1007. Yes, they are precise hosts:
Info: Sleeping for 52 seconds (splay is enabled) Info: Retrieving plugin Info: Loading facts in /var/lib/puppet/lib/facter/raid.rb Info: Loading facts in /var/lib/puppet/lib/facter/puppet_vardir.rb Info: Loading facts in /var/lib/puppet/lib/facter/ganeti.rb Info: Loading facts in /var/lib/puppet/lib/facter/physicalcorecount.rb Info: Loading facts in /var/lib/puppet/lib/facter/root_home.rb Info: Loading facts in /var/lib/puppet/lib/facter/initsystem.rb Info: Loading facts in /var/lib/puppet/lib/facter/apt.rb Info: Loading facts in /var/lib/puppet/lib/facter/lldp.rb Info: Loading facts in /var/lib/puppet/lib/facter/puppet_config_dir.rb Info: Loading facts in /var/lib/puppet/lib/facter/pe_version.rb Info: Loading facts in /var/lib/puppet/lib/facter/labsprojectfrommetadata.rb Info: Loading facts in /var/lib/puppet/lib/facter/lvm_support.rb Info: Caching catalog for labsdb1006.eqiad.wmnet Info: Applying configuration version '1477319941' Error: Execution of '/usr/bin/apt-get -q -y -o DPkg::Options::=--force-confold install postgresql-9.1-postgis-scripts' returned 100: Reading package lists... Building dependency tree... Reading state information... E: Unable to locate package postgresql-9.1-postgis-scripts E: Couldn't find any package by regex 'postgresql-9.1-postgis-scripts' Error: /Stage[main]/Postgresql::Postgis/Package[postgresql-9.1-postgis-scripts]/ensure: change from purged to present failed: Execution of '/usr/bin/apt-get -q -y -o DPkg::Options::=--force-confold install postgresql-9.1-postgis-scripts' returned 100: Reading package lists... Building dependency tree... Reading state information... E: Unable to locate package postgresql-9.1-postgis-scripts E: Couldn't find any package by regex 'postgresql-9.1-postgis-scripts'
Change 317527 had a related patch set uploaded (by Gehel):
postgis - postgis scripts package does not exist for precise
Change 317527 merged by Gehel:
postgis - postgis scripts package does not exist for precise