[pgrouting-dev] [postgis-devel] Issue installing postgis-2.0 in Pg 9.3

pgRouting pgrouting-dev
1

Steve,

PostGIS 2.0 is not supported for Pg 9.3. We had patched up 2.1 with the
htup_details.h to work with 9.3 (pgRouting is fine I think because we had
already patched it for 9.3 when I noticed the same issue a while ago)

You need to run PostGIS 2.1 or above with 9.3.

The fixes you've been seeing on the net are people patching up 2.0 to work
with 9.3 which is not a supported mix. See matrix for details --
http://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS

Hope that helps,
Regina

-----Original Message-----
From: postgis-devel-bounces@lists.osgeo.org
[mailto:postgis-devel-bounces@lists.osgeo.org] On Behalf Of Stephen
Woodbridge
Sent: Tuesday, April 15, 2014 3:33 PM
To: PostGIS Development Discussion
Subject: [postgis-devel] Issue installing postgis-2.0 in Pg 9.3

Hi devs,

I just noticed that the pgrouting travis instance is failing when we try to
create a postgresql 9.3 and install postgis-2.0 into it with the follow
error:

ERROR: could not load library
"/usr/lib/postgresql/9.3/lib/postgis-2.0.so":
/usr/lib/postgresql/9.3/lib/postgis-2.0.so: undefined symbol: GETSTRUCT

This is running Ubuntu precise? and probably packages from the Ubuntu GIS
ppa from launchpad.

So two questions:

1. Is this known/fixed/etc? Are we just out of date on travis?

2. For pgRouting, will I need to add something like:

#if POSTGIS_PGSQL_VERSION >= 93
#include "access/htup_details.h"
#endif

To all my C functions that are called from plpgsql?

Thanks,
   -Steve
_______________________________________________
postgis-devel mailing list
postgis-devel@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel

2

Regina,

Thank you for looking into this and relaying that information.

Daniel,

When you have a chance it sounds like we need travis updated to only support the matrix below.

Thanks,
   -Steve

On 4/15/2014 4:44 PM, Paragon Corporation wrote:

Steve,

PostGIS 2.0 is not supported for Pg 9.3. We had patched up 2.1 with the
htup_details.h to work with 9.3 (pgRouting is fine I think because we had
already patched it for 9.3 when I noticed the same issue a while ago)

You need to run PostGIS 2.1 or above with 9.3.

The fixes you've been seeing on the net are people patching up 2.0 to work
with 9.3 which is not a supported mix. See matrix for details --
http://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS

Hope that helps,
Regina

-----Original Message-----
From: postgis-devel-bounces@lists.osgeo.org
[mailto:postgis-devel-bounces@lists.osgeo.org] On Behalf Of Stephen
Woodbridge
Sent: Tuesday, April 15, 2014 3:33 PM
To: PostGIS Development Discussion
Subject: [postgis-devel] Issue installing postgis-2.0 in Pg 9.3

Hi devs,

I just noticed that the pgrouting travis instance is failing when we try to
create a postgresql 9.3 and install postgis-2.0 into it with the follow
error:

ERROR: could not load library
"/usr/lib/postgresql/9.3/lib/postgis-2.0.so":
/usr/lib/postgresql/9.3/lib/postgis-2.0.so: undefined symbol: GETSTRUCT

This is running Ubuntu precise? and probably packages from the Ubuntu GIS
ppa from launchpad.

So two questions:

1. Is this known/fixed/etc? Are we just out of date on travis?

2. For pgRouting, will I need to add something like:

#if POSTGIS_PGSQL_VERSION >= 93
#include "access/htup_details.h"
#endif

To all my C functions that are called from plpgsql?

Thanks,
    -Steve
_______________________________________________
postgis-devel mailing list
postgis-devel@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel

_______________________________________________
pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

3

OK, it’s just necessary to comment out one line in the Travis configuration.
Will do it.

Daniel

···

On Wed, Apr 16, 2014 at 10:13 AM, Stephen Woodbridge <woodbri@swoodbridge.com> wrote:

Regina,

Thank you for looking into this and relaying that information.

Daniel,

When you have a chance it sounds like we need travis updated to only support the matrix below.

Thanks,
-Steve

On 4/15/2014 4:44 PM, Paragon Corporation wrote:

Steve,

PostGIS 2.0 is not supported for Pg 9.3. We had patched up 2.1 with the
htup_details.h to work with 9.3 (pgRouting is fine I think because we had
already patched it for 9.3 when I noticed the same issue a while ago)

You need to run PostGIS 2.1 or above with 9.3.

The fixes you’ve been seeing on the net are people patching up 2.0 to work
with 9.3 which is not a supported mix. See matrix for details –
http://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS

Hope that helps,
Regina

-----Original Message-----
From: postgis-devel-bounces@lists.osgeo.org
[mailto:postgis-devel-bounces@lists.osgeo.org] On Behalf Of Stephen
Woodbridge
Sent: Tuesday, April 15, 2014 3:33 PM
To: PostGIS Development Discussion
Subject: [postgis-devel] Issue installing postgis-2.0 in Pg 9.3

Hi devs,

I just noticed that the pgrouting travis instance is failing when we try to
create a postgresql 9.3 and install postgis-2.0 into it with the follow
error:

ERROR: could not load library
“/usr/lib/postgresql/9.3/lib/postgis-2.0.so”:
/usr/lib/postgresql/9.3/lib/postgis-2.0.so: undefined symbol: GETSTRUCT

This is running Ubuntu precise? and probably packages from the Ubuntu GIS
ppa from launchpad.

So two questions:

  1. Is this known/fixed/etc? Are we just out of date on travis?

  2. For pgRouting, will I need to add something like:

#if POSTGIS_PGSQL_VERSION >= 93
#include “access/htup_details.h”
#endif

To all my C functions that are called from plpgsql?

Thanks,
-Steve

postgis-devel mailing list
postgis-devel@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel

pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

pgrouting-dev mailing list
pgrouting-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-dev

–

Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.info