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

[Robert W. Burgholzer]

I am unclear here, are the appropriate libraries in the places that the 
postgis.sql script wants them to be?

If need be, you may have to copy the libraries manually:


cp /usr/local/src/postgresql-7.3.3/contrib/postgis-cvs/libpostgis.so.0.8 
/usr/local/pgsql/lib/

This is a better solution than changing lib dirs and so forth, I think.

rob

>===== Original Message From PostGIS Users Discussion 
<postgis-users at postgis.refractions.net> =====
>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.sq
l: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.sq
l: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.sq
l
>> :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
>>
>>
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users

Robert W. Burgholzer
rburghol at veetee dot edu
History of Nutrition: "Buddha probably consumed a high-carb diet."