[postgis-users] Issues with compiling PostGIS 1.5.8 on FreeBSD

Paul Gabriel mista_pink at web.de
Sun Jan 18 10:21:39 PST 2015


Dear Regina,

Somehow the ports got updated. Which means we lost postgis 1.5 binaries. But the data in the database is now not accessible anymore. I read about a "hard update" in the docs. When I tried to use pg_dump to get the old data I get the following error:

pg_dump: Error message from server: ERROR:  Unknown geometry type: -1099038720 - Unknown

So my best idea was to pull 1.5.3 (most recent used by ports) and 1.5.8 (most recent available from source), go through the files from http://svn.freebsd.org/ports/tags/RELEASE_9_2_0/databases/postgis/ and try to find the needed flags etc.

The port pulled the source code from the same repo as I did and no patches were applied (if I understand databases/postgis properly).

What do you think would be the best way to proceed?

Thanks in advance,
Paul

PS: 2.1.5 compiled fine.


 

Gesendet: Sonntag, 18. Januar 2015 um 18:24 Uhr
Von: "Paragon Corporation" <lr at pcorp.us>
An: "'PostGIS Users Discussion'" <postgis-users at lists.osgeo.org>
Betreff: Re: [postgis-users] Issues with compiling PostGIS 1.5.8 on FreeBSD
Paul,
Is there a reason you are trying to use PostGIS 1.5.8 instead of PostGIS
2.1.5?

There are quite a few FreeBSD fixes as I recall that were put in PostGIS 2.1
branch that were never backported to 1.5 branch.

Thanks,
Regina
http://www.postgis.us
http://postgis.net


-----Original Message-----
From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of
mista_pink at web.de
Sent: Sunday, January 18, 2015 12:12 PM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] Issues with compiling PostGIS 1.5.8 on FreeBSD


Hi,
 
I tried building postgis 1.5.8 on FreeBSD (9.2) but it crashes:
 
cc -O2 -pipe -O3 -funroll-loops -fno-strict-aliasing -Wall
-Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement
-Wendif-labels -Wformat-security -fno-strict-aliasing -fwrapv -fPIC -DPIC
-I/usr/local/include -I/usr/local//include -I/usr/local/include/libxml2
-I/usr/local/include -I../liblwgeom -I. -I.
-I/usr/local/include/postgresql/server
-I/usr/local/include/postgresql/internal -I/usr/local/include
-I/usr/local/include  -c -o lwgeom_pg.o lwgeom_pg.c In file included from
lwgeom_pg.c:7:
lwgeom_pg.h:72: error: expected '=', ',', ';', 'asm' or '__attribute__'
before '*' token
lwgeom_pg.h:73: error: expected ')' before '*' token
lwgeom_pg.h:76: error: expected '=', ',', ';', 'asm' or '__attribute__'
before '*' token
lwgeom_pg.h:77: error: expected ')' before '*' token
lwgeom_pg.h:80: error: expected '=', ',', ';', 'asm' or '__attribute__'
before '*' token
lwgeom_pg.h:81: error: expected ')' before '*' token
lwgeom_pg.c:135: warning: no previous prototype for 'lwgeom_init_allocators'
lwgeom_pg.c: In function 'lwgeom_init_allocators':
lwgeom_pg.c:137: error: 'lwalloc_var' undeclared (first use in this
function)
lwgeom_pg.c:137: error: (Each undeclared identifier is reported only once
lwgeom_pg.c:137: error: for each function it appears in.)
lwgeom_pg.c:138: error: 'lwrealloc_var' undeclared (first use in this
function)
lwgeom_pg.c:139: error: 'lwfree_var' undeclared (first use in this function)
lwgeom_pg.c:140: error: 'lwerror_var' undeclared (first use in this
function)
lwgeom_pg.c:141: error: 'lwnotice_var' undeclared (first use in this
function)
lwgeom_pg.c: At top level:
lwgeom_pg.c:144: error: expected '=', ',', ';', 'asm' or '__attribute__'
before '*' token
lwgeom_pg.c:179: error: expected ')' before '*' token
lwgeom_pg.c:219: error: expected '=', ',', ';', 'asm' or '__attribute__'
before '*' token
lwgeom_pg.c:288: error: expected '=', ',', ';', 'asm' or '__attribute__'
before '*' token
lwgeom_pg.c:321: error: expected ')' before '*' token
lwgeom_pg.c:346: error: expected '=', ',', ';', 'asm' or '__attribute__'
before '*' token
lwgeom_pg.c:447: error: expected ')' before '*' token
gmake[1]: *** [lwgeom_pg.o] Error 1
gmake[1]: Leaving directory `/home/mp/postgis-1.5.8/postgis'
gmake: *** [postgis] Error 2
*** [all] Error code 2 

Stop in /home/mp/postgis-1.5.8. 
 
 
I guess I'm missing a compiler flag? I also took a look at the old ports
makefile which didn't reveal any specific flag. It compiles fine with CentOS
though. I have added the same flags as on CentOS, but it didn't work out.

Any hints are appreciated.

Cheers,
Paul
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users[http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users]


_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users[http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users]


More information about the postgis-users mailing list