[postgis-users] Re: GEOS install help for Solaris 9

[Matthew Perry]

Hello all,
  I ran XMLTester to confirm that the GEOS libraries
are functioning. All 490 tests passed, 0 failed. So am
I correct in assuming that GEOS was installed
properly?

If GEOS is installed correctly, why can't postgis
access the GEOS functions?

- libgeos.so is in /usr/local/lib/
- Our postgis makefile has the following lines:
   USE_GEOS=1
   ifeq (${GEOS_DIR},)
        GEOS_DIR=/usr/local
   endif
- All the other non-geos postgis functions are working
properly.

I am out of ideas! Does anyone have any suggestions
about what we should check next??

Thanks,

Matthew Perry
Humboldt State University
Environmental and Natural Resource Sciences


Paul Ramsey wrote:
>Start with the XMLTester, that exercises things a bit
>more.

Matthew Perry wrote:

> Hello,
> 
>   We are trying to run postgis on Solaris 9.
> Everything is ok except for the GEOS functions.
> For example, check out the following output from
> psql...
> --------------------------
> 
> test=# select intersection('POINT(1 1)', 'POINT(1
> 1)');
> server closed the connection unexpectedly
>         This probably means the server terminated
> abnormally
>         before or while processing the request.
> The connection to the server was lost. Attempting
> reset: Failed.
> !> select * from pg_tables;
> You are currently not connected to a database.
> !> 
> 
> The logfile provides the following:
> ----------------------------------
> 
> LOG:  server process (PID 19666) was terminated by
> signal 11
> LOG:  terminating any other active server processes
> LOG:  all server processes terminated;
reinitializing
> LOG:  database system was interrupted at 2004-08-05
> 13:55:59 PDT
> LOG:  checkpoint record is at 0/C75FA8
> LOG:  redo record is at 0/C75FA8; undo record is at
> 0/0; shutdown TRUE
> LOG:  next transaction ID: 558; next OID: 27382
> LOG:  database system was not properly shut down;
> automatic recovery in progress
> FATAL:  the database system is starting up
> LOG:  invalid magic number 0000 in log file 0,
segment
> 0, offset 13066240
> LOG:  redo is not required
> LOG:  database system is ready
> 
> ------------------------------
> 
> So is it reasonable to assume that GEOS was not
> installed properly? How would I test this? I noticed
a
> little app that comes with GEOS called
> "SimpleWKTTester" but can't make it do anything, nor
> can I find any documentation on it. 
> 
> Any ideas? Anyone have any experience with this
> problem on Solaris before?
> 
> Thanks for the input,
> 
> Matthew Perry
> Humboldt State University
> Environmental and Natural Resource Sciences