Thanks Tom, On Mon, Jun 23, 2008 at 7:53 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > "P Kapat" <kap4lin@xxxxxxxxx> writes: >> If I understand correctly, the shared libraries for postgis should be >> inside $PKGLIBDIR for the server to see them. Is there any userland >> configuration (like adding $HOME/usr/local/lib to ~/.psqlrc) that will >> solve this? > > Do you have superuser privs on the database? If so, you could try > altering the SQL files for postgis etc to reference the shared libraries > where you put them. But that likely won't work if SELinux is enabled > on the system. As it happens, I do have superuser privs on the database but (as it also happens!) SELinux is enabled on this system. > If you don't have superuser then you have no hope of installing these > modules without admin intervention, because you can't execute the CREATE > FUNCTION commands, independently of where the shlibs are. Two questions in that case: 1. How should the admin go about adding $HOME/usr/local/lib to $PKGLIBDIR? 2. (this is extraneous to the current issue) How is ~/.psqlrc useful to me? Links to any HOWTOS / Docs will be much appreciated. > regards, tom lane Regards, -- Regards PK -------------------------------------- http://counter.li.org #402424
