Обсуждение: correct installation of postgis ??

hi every one
   i had install postgis step by step, every thing is
working good untile the last step.
when i type (psql -d [mydatabase] -f [postgis.sql])
command, i found alot of replies i can't see upper
collection of them, but i recieve this line as an
example
psql:postgis.sql:2393: ERROR:  current transaction is
aborted, queries ignored until end of transaction
block.

i can't determine if i made the correct installation
or there is a hidden error
                     thank you
                     Ahmed Mousaad





_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com

On Tue, 5 Oct 2004, Ahmed Mousaad wrote:

> hi every one
>    i had install postgis step by step, every thing is
> working good untile the last step.
> when i type (psql -d [mydatabase] -f [postgis.sql])
> command, i found alot of replies i can't see upper
> collection of them, but i recieve this line as an
> example
> psql:postgis.sql:2393: ERROR:  current transaction is
> aborted, queries ignored until end of transaction
> block.
>
> i can't determine if i made the correct installation
> or there is a hidden error

This is certainly not a good install.  The error message only indicates
that something went wrong earlier.  You'll need to determine what the
first error is and that should tell us what went wrong.

Kris Jurka

hi,
here is the first error i get when i wrote (psql -d
[mydatabase] -f postgis.sql)

psql:postgis.sql:42: ERROR:  Load of file
/usr/local/pgsql/lib/libpostgis.so.0.9 failed:
libgeos.so.2: cannot open shared object file: No such
file or directory***(Single step mode: Verify
query)*********************************************CREATE
OR REPLACE FUNCTION histogram2d_out(histogram2d)

thanks
Ahmed mousaad



_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com

On Wed, 6 Oct 2004, Ahmed Mousaad wrote:

> psql:postgis.sql:42: ERROR:  Load of file
> /usr/local/pgsql/lib/libpostgis.so.0.9 failed:
> libgeos.so.2: cannot open shared object file: No such

This error is the dynamic loader complaining it can't find the libgeos
library.  You need to alter ld.so.conf or LD_LIBRARY_PATH to include the
location of the geos library.

Kris Jurka