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

[Moen, Paul T.]

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
>
>