[postgis-users] 2.1.0beta3dev upgrade error

[Stephen Woodbridge]

Some more data points. I also created a new database and tried:

pgis21=# create extension postgis;
ERROR:  could not load library 
"/usr/lib/postgresql/9.2/lib/postgis-2.1.so": 
/usr/lib/postgresql/9.2/lib/postgis-2.1.so: undefined symbol: 
json_tokener_errors
pgis21=# create extension postgis version '2.0.3';
ERROR:  could not load library 
"/usr/lib/postgresql/9.2/lib/rtpostgis-2.0.so": libgdal1.6.0.so.1: 
cannot open shared object file: No such file or directory

So I rebuilt postgis 2.0.3 to use the new gdal that I installed for 2.1 
and tried "create extension postgis;" and this installed 2.0.3 by default.

pgis21=# drop extension postgis ;
DROP EXTENSION

pgis21=# create extension postgis version '2.1.0beta3dev';
CREATE EXTENSION

and now it loaded 2.1 ok.

Not sure what caused the strangeness, but it seems to be working there, 
but when I run my pgrouting test script:

woodbri at maps:~/work/pgrouting$ tools/test-runner.pl
RUNNING: test-runner.pl
ERROR:  could not load library 
"/usr/lib/postgresql/9.2/lib/postgis-2.0.so": 
/usr/lib/postgresql/9.2/lib/postgis-2.0.so: undefined symbol: 
json_tokener_errors
ERROR:  required extension "postgis" is not installed

This creates a new database, adds postgis and pgrouting and then runs 
tests in that database.

-Steve

On 5/23/2013 1:01 AM, Stephen Woodbridge wrote:
> Hi all,
>
> I just tried to upgrade postgis from 2.0.3 -> 2.1.0beta3dev and got the
> following error:
>
> pgr_test=# alter extension postgis update to '2.1.0beta3dev';
> ERROR:  could not load library
> "/usr/lib/postgresql/9.2/lib/postgis-2.1.so":
> /usr/lib/postgresql/9.2/lib/postgis-2.1.so: undefined symbol:
> json_tokener_errors
>
> Did I forget a step or do something wrong?
>
> -Steve
>
> I have json-c-0.11 built and installed. In fact is is the ./configure
> report:
>
>    PostGIS is now configured for i686-pc-linux-gnu
>
>   -------------- Compiler Info -------------
>    C compiler:           gcc -g -O2
>    C++ compiler:         g++ -g -O2
>    SQL preprocessor:     /usr/bin/cpp -traditional-cpp -P
>
>   -------------- Dependencies --------------
>    GEOS config:          /usr/local/bin/geos-config
>    GEOS version:         3.3.8
>    GDAL config:          /usr/local/bin/gdal-config
>    GDAL version:         1.9.2
>    PostgreSQL config:    /usr/lib/postgresql/9.2/bin/pg_config
>    PostgreSQL version:   PostgreSQL 9.2.4
>    PROJ4 version:        47
>    Libxml2 config:       /usr/bin/xml2-config
>    Libxml2 version:      2.7.8
>    JSON-C support:       yes
>    PostGIS debug level:  0
>    Perl:                 /usr/bin/perl
>
>   --------------- Extensions ---------------
>    PostGIS Raster:       enabled
>    PostGIS Topology:     enabled
>    SFCGAL support:       disabled
>
>   -------- Documentation Generation --------
>    xsltproc:             /usr/bin/xsltproc
>    xsl style sheets:
>    dblatex:
>    convert:
>    mathml2.dtd:          http://www.w3.org/Math/DTD/mathml2/mathml2.dtd
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users