[postgis-users] Re: failure to load postgis.sql

[Byron Amerson]

Thanks for the response Jean,

However that solution did not work out.

It seems strange that the libs/dylibs are there(in
/usr/local/src/postgresql/postgesql-7.4/contrib/postgis-0.8.0) but are
not being found or utilized properly.

Is it possible that I did something wrong when I compiled?  all of the
libs and other files that were made still live in the postgresql source
tree, is this right?  Should'nt they be in /usr/local/pgsql/* ?  It seems
funny to have to change the $libdir varibale to an absolute path, but I am
truly ignorant of C and its vagaries. Besides, the error message is
identical, so I don't think that I needed to change libdir path. I am on
an imac running os10.3.1 and using postgresql-7.4 along with postgis-0.8.0,
proj4 and geos.

The error message is in the text below.  Any help or insight into this
issue would be greatly appreciated.

Byron Amerson
MS student
University of Washington
Department of Earth and Space Sciences

On Sat, 29 Nov 2003, Byron Amerson wrote:

> Hello,
>
> Finally have compiled postgis-0.80 for my mac running osx10.3.1 with
> postgresql-7.4. I also have proj4 and geos compiled as well. No problems
> there.
>
> but when attempting to load postgis.sql I get the following error:
>
> [Tectonic:~] postgres% psql -d gistest -f
> /usr/local/src/postgresql/postgresql-7.4/contrib/postgis-0.8.0/postgis.sql
> BEGIN
>         message
> ------------------------
>  PL/PgSQL is installed.
> (1 row)
>
> psql:/usr/local/src/postgresql/postgresql-7.4/contrib/postgis-0.8.0/postgis.sql:41:
> NOTICE:  type "histogram2d" is not yet defined
> DETAIL:  Creating a shell type definition.
> psql:/usr/local/src/postgresql/postgresql-7.4/contrib/postgis-0.8.0/postgis.sql:41:
> ERROR:  could not load library "/usr/local/pgsql/lib/libpostgis.so.0.8":
> dyld: /usr/local/pgsql/bin/postmaster Undefined symbols:
> __ZNSs20_S_empty_rep_storageE
> __ZNSs4_Rep11_S_max_sizeE
> __ZNSs4_Rep11_S_terminalE
> __ZNSt24__default_alloc_templateILb1ELi0EE12_S_force_newE
> __ZNSt24__default_alloc_templateILb1ELi0EE12_S_free_listE
> __ZNSt24__default_alloc_templateILb1ELi0EE22_S_node_allocator_lockE
> __ZTIPv
> __ZTVN10__cxxabiv117__class_type_infoE
> __ZTVN10__cxxabiv119__pointer_type_infoE
> __ZTVN10__cxxabiv120__si_class_type_infoE
> __ZTVN10__cxxabiv121__vmi_class_type_infoE
> ___cxa_pure_virtual
> ___gxx_personality_v0
>
> psql:/usr/local/src/postgresql/postgresql-7.4/contrib/postgis-0.8.0/postgis.sql
> :46: ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
>
> ...etc...
>
> Any suggestions?? Thanks for any help in advance.
>
>
> Byron Amerson
> MS student
> University of Washington
> Department of Earth and Space Sciences
>
>