Thanks Tom, On Mon, Jun 23, 2008 at 7:53 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "P Kapat" <[EMAIL PROTECTED]> 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 -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
