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

[Byron Amerson]

Hi There,

It took me a few days to get back to this issue, but I am still having
this problem.
I re-compiled postgres-7.4 and was sure to set the environment variable
LDFLAGS=-lstdc++, I noticed that configure saw that this was set.

I also insured that everthing for postgis was installed where it should
be (/usr/local/pgsql/*). geos in /usr/local/* and proj in the same.

so the command:
[Tectonic:~] postgres% psql -f /usr/local/pgsql/share/postgis.sql -d gistest

results in the following error messages:

test
BEGIN
        message
------------------------
 PL/PgSQL is installed.
(1 row)

psql:/usr/local/pgsql/share/contrib/postgis.sql:41: NOTICE:  type
"histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
psql:/usr/local/pgsql/share/contrib/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/pgsql/share/contrib/postgis.sql:46: ERROR:  current
transaction is aborted, commands ignored until end of transaction block

< snip >


Why don't the libs work?  Is it possible even though the environment
variable was set things did not work properly during configure/make?


Any help would be appreciated.  again, macosx10.3.1.

Thanks...

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

On Mon, 1 Dec 2003, Byron Amerson wrote:

> I am not  at the computer where I am attempting to build postgis, none the
> less,
>
> in attempting the following LDFLAGS=-lstdc ./compile
>
> my system barked that it did not know the command LDFLAGS.
>
> So I set an environment variable like so:
>
> setenv LADFLAGS -lstdc
>
> and indeed it showed up as LDFLAGS=-lstdc when I checked using env.
>
> so I went ahead and compiled.
>
> evidently this either did not work as expected or was not the right way to
> proceed.
>
> Byron Amerson
> MS student
> University of Washington
> Department of Earth and Space Sciences
>
>