Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 223AB6515F7 for ; Mon, 23 Jun 2008 20:53:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 04058-03 for ; Mon, 23 Jun 2008 20:53:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 11E816514DA for ; Mon, 23 Jun 2008 20:53:08 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m5NNr5R6004990; Mon, 23 Jun 2008 19:53:05 -0400 (EDT) To: "P Kapat" cc: pgsql-admin@postgresql.org Subject: Re: adding a user library path.. In-reply-to: References: Comments: In-reply-to "P Kapat" message dated "Mon, 23 Jun 2008 19:39:52 -0400" Date: Mon, 23 Jun 2008 19:53:05 -0400 Message-ID: <4989.1214265185@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/199 X-Sequence-Number: 29537 "P Kapat" 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. 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. regards, tom lane