[postgis-users] problem occured when installing postgis,help me

[boo hou]

Thanks very much. Problem was solved! It's like what
you said,
I forgot to add /usr/local/lib to /etc/ld.so.conf and
run /sbin/ldconfig. You helped me a lot. Happy New
Year!!
 

 --- strk at refractions.net 的正文：
> On Wed, Dec 29, 2004 at 12:22:49PM +0800, boo hou
> wrote:
> > The problem occured at the moment when i execute
> #psql
> > -d mydb -f /usr/local/pgsql/share/postgis/sql, the
> > transactions were aborted. Then i   resort the
> errors
> > into a file to trace the reason. What i got is as
> > follows. It's sure pl/pgsql is installed. So
> what's
> > wrong with it? Please help me. Thanx in advance!
> 
> It's not finding libgeos.so.2
> If you DID install GEOS run ldconfig.
> If you DID NOT install GOES set USE_GEOS=1
> in Makefile.config.
> 
> --strk;
> 
> > 
> > BEGIN
> >         message         
> > ------------------------
> >  PL/PgSQL is installed.
> > (1 row)
> > 
> > COMMIT
> > psql:postgis.sql:47: NOTICE:  type "histogram2d"
> is
> > not yet defined
> > DETAIL:  Creating a shell type definition.
> > psql:postgis.sql:47: ERROR:  could not load
> library
> > "/usr/local/pgsql/lib/libpostgis.so.0.9":
> > libgeos.so.2: cannot open shared object file: No
> such
> > file or directory
> > psql:postgis.sql:52: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:60: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:77: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:82: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:89: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:106: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:111: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:118: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:135: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:140: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:146: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:151: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:163: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:180: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:185: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:193: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:210: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:215: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:233: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:260: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:271: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:293: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:301: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:305: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:309: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:313: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:317: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:321: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:325: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:368: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:407: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:414: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:447: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:572: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:685: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:705: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:724: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:747: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:753: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:764: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> > psql:postgis.sql:769: ERROR:  current transaction
> is
> > aborted, commands ignored until end of transaction
> > block
> 
=== message truncated === 

_________________________________________________________
Do You Yahoo!?
150万曲MP3疯狂搜，带您闯入音乐殿堂
http://music.yisou.com/
美女明星应有尽有，搜遍美图、艳图和酷图
http://image.yisou.com
1G就是1000兆，雅虎电邮自助扩容！
http://cn.rd.yahoo.com/mail_cn/tag/1g/*http://cn.mail.yahoo.com/event/mail_1g/