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

Byron Amerson byronea at u.washington.edu
Thu Dec 4 23:12:48 PST 2003

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:

 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:

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.


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

More information about the postgis-users mailing list