[postgis-users] [postgis-devel] Extension upgrade has no update path 2.1.1 to 2.1.7

[Moen, Paul T.]

FYI.

EnterpriseDB has fixed the problem with the installer in the latest
download via their stackbuilder app. The latest download is PostGIS 2.1.8
and it includes the appropriate upgrade sql files.

Thanks,

Paul

On 7/22/15, 7:18 AM, "postgis-users-bounces at lists.osgeo.org on behalf of
Moen, Paul T." <postgis-users-bounces at lists.osgeo.org on behalf of
pmoen at nd.gov> wrote:

>Thank you for the reply.
>
>I think it is a problem with the installer we use from EnterpriseDB and
>not a bug with PostGIS.
>
>I tried installing PostgreSQL and Postgis using a different installer from
>KyngChaos.  Once everything was installed I compared files in the
>directories and found many missing files.  I assume these files are
>created when compiling the code?
>
>I am using the PostgreSQL/Stackbuilder combination from EnterpriseDB and I
>believe the installer does not include the appropriate files.  I see on
>PostGIS¹s homepage, there is a recommendation not to use EnterpriseDB, due
>to mixed reliability. Case in point. We however, do use them and will be
>contacting them with the problem. I will send an update if anyone is
>interested when they get this fixed.
>
>
>
>postgis--2.0.0--2.1.7.sql
>postgis--2.0.1--2.1.7.sql
>postgis--2.0.2--2.1.7.sql
>postgis--2.0.3--2.1.7.sql
>postgis--2.0.4--2.1.7.sql
>postgis--2.0.5--2.1.7.sql
>postgis--2.0.6--2.1.7.sql
>postgis--2.1.0--2.1.7.sql
>postgis--2.1.0rc1--2.1.7.sql
>postgis--2.1.0rc2--2.1.7.sql
>postgis--2.1.0rc3--2.1.7.sql
>postgis--2.1.1--2.1.7.sql
>postgis--2.1.2--2.1.7.sql
>postgis--2.1.3--2.1.7.sql
>postgis--2.1.4--2.1.7.sql
>postgis--2.1.5--2.1.7.sql
>postgis--2.1.6--2.1.7.sql
>postgis--2.1.7--2.1.7next.sql
>postgis--2.1.7next--2.1.7.sql
>postgis--unpackaged--2.1.7.sql
>postgis_tiger_geocoder--2.0.0--2.1.7.sql
>postgis_tiger_geocoder--2.0.1--2.1.7.sql
>postgis_tiger_geocoder--2.0.2--2.1.7.sql
>postgis_tiger_geocoder--2.0.3--2.1.7.sql
>postgis_tiger_geocoder--2.0.4--2.1.7.sql
>postgis_tiger_geocoder--2.0.5--2.1.7.sql
>postgis_tiger_geocoder--2.0.6--2.1.7.sql
>postgis_tiger_geocoder--2.1.0--2.1.7.sql
>postgis_tiger_geocoder--2.1.0rc1--2.1.7.sql
>postgis_tiger_geocoder--2.1.0rc2--2.1.7.sql
>postgis_tiger_geocoder--2.1.0rc3--2.1.7.sql
>postgis_tiger_geocoder--2.1.1--2.1.7.sql
>postgis_tiger_geocoder--2.1.2--2.1.7.sql
>postgis_tiger_geocoder--2.1.3--2.1.7.sql
>postgis_tiger_geocoder--2.1.4--2.1.7.sql
>postgis_tiger_geocoder--2.1.5--2.1.7.sql
>postgis_tiger_geocoder--2.1.6--2.1.7.sql
>postgis_tiger_geocoder--2.1.7--2.1.7next.sql
>postgis_tiger_geocoder--2.1.7next--2.1.7.sql
>postgis_tiger_geocoder--unpackaged--2.1.7.sql
>postgis_topology--2.0.0--2.1.7.sql
>postgis_topology--2.0.1--2.1.7.sql
>postgis_topology--2.0.2--2.1.7.sql
>postgis_topology--2.0.3--2.1.7.sql
>postgis_topology--2.0.4--2.1.7.sql
>postgis_topology--2.0.5--2.1.7.sql
>postgis_topology--2.0.6--2.1.7.sql
>postgis_topology--2.1.0--2.1.7.sql
>postgis_topology--2.1.0rc1--2.1.7.sql
>postgis_topology--2.1.0rc2--2.1.7.sql
>postgis_topology--2.1.0rc3--2.1.7.sql
>postgis_topology--2.1.1--2.1.7.sql
>postgis_topology--2.1.2--2.1.7.sql
>postgis_topology--2.1.3--2.1.7.sql
>postgis_topology--2.1.4--2.1.7.sql
>postgis_topology--2.1.5--2.1.7.sql
>postgis_topology--2.1.6--2.1.7.sql
>postgis_topology--2.1.7--2.1.7next.sql
>postgis_topology--2.1.7next--2.1.7.sql
>postgis_topology--unpackaged--2.1.7.sql
>
>
>
>
>On 7/22/15, 1:22 AM, "Paragon Corporation" <lr at pcorp.us> wrote:
>
>>Paul,
>>
>>I just checked my build and I have a 2.1.1-2.1.7.sql so whatever the
>>issue is I don't think is a bug in PostGIS.
>>
>>Can you check your share/extension folder of your postgresql install and
>>verify that you do have a  file called postgis-2.1.1--2.1.7.sql ?
>>
>>I suspect you don't.  If you do have all the postgis extension files you
>>should also have a file called postgis--2.1.7.sql
>>
>>
>>Did you build PostGIS yourself or got from a distribution?  Could be a
>>packaging flaw that you need to report to the package maintainer that you
>>are missing extension files.
>>
>>
>>Thanks,
>>Regina
>>http://www.postgis.us
>>http://postgis.net
>>
>>
>>-----Original Message-----
>>From: postgis-devel-bounces at lists.osgeo.org
>>[mailto:postgis-devel-bounces at lists.osgeo.org] On Behalf Of Sandro
>>Santilli
>>Sent: Tuesday, July 21, 2015 12:11 PM
>>To: Moen, Paul T. <pmoen at nd.gov>
>>Cc: postgis-devel at lists.osgeo.org
>>Subject: Re: [postgis-devel] [postgis-users] Extension upgrade has no
>>update path 2.1.1 to 2.1.7
>>
>>On Mon, Jul 20, 2015 at 08:25:04PM +0000, Moen, Paul T. wrote:
>>> I am upgrading from postgis 2.1.1 to 2.1.7 using extensions.
>>> 
>>> After entering the following,
>>> 
>>> ALTER EXTENSION postgis UPDATE TO "2.1.7�;
>>> 
>>> I get error
>>> 
>>> ERROR:  extension "postgis" has no update path from version "2.1.1" to
>>>version "2.1.7"
>>
>>Sounds like a bug, could you please file it on trac ?
>>http://trac.osgeo.org/postgis/
>>
>>--strk;
>>_______________________________________________
>>postgis-devel mailing list
>>postgis-devel at lists.osgeo.org
>>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel
>>
>>
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at lists.osgeo.org
>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users