Im having problem installing postgis to an existing database. but getting error like this:
ERROR: could not load library "/usr/local/pgsql/lib/postgis-2.0.so": libgeos_c.so.1: cannot open shared object file: No such file or directory
the postgis-2.0.so is in /usr/local/pgsql/lib/postgis-2.0.so no problem. the libgeos_c.so.1 is installed in /usr/local/lib.
So, what is the problem here?
Any help would be appreciated.
Thanks.
BTW, I installed all these followed by this tutorial:
http://www.codingsteps.com/installing-and-configuring-postgresql-in-amazon-linux-ami/
update
$ ldd /usr/local/lib/libgeos_c.so.1
linux-vdso.so.1 => (0x00007fff6f55b000)
libgeos-3.3.7.so => /usr/local/lib/libgeos-3.3.7.so (0x00007f53700d9000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f536fdd0000)
libm.so.6 => /lib64/libm.so.6 (0x00007f536fb4c000)
libc.so.6 => /lib64/libc.so.6 (0x00007f536f7c0000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f536f5ab000)
/lib64/ld-linux-x86-64.so.2 (0x00007f537068d000)
It's been a while since I've solved this problem, and almost forgot this question i asked before. I found still getting upvote from guys might having this issue.
So basically, I found this issue might be happening because of the postgis plugin which i installed by sudo apt-get install postgis wasn't properly installed into the position which PostgreSQl database preferred. Im really not a linux guy to make sure of this. But seems every time I try installing postgis this way, this error will just show up.
So the cure for this issue is, download, build and install the postgis from the source code.
I followed this wiki. hope its helpful to someone.