DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=kHuwprAQlAWI6yvLAnHo8TbMukgCv0ryieOmvRNyGnGtAfP3sY5EsDlsrGsLTvRmMp
	NFlboUYMVBWi10cGvvdXVDgiLRkgJ550DiDt+hG4djkZugJ8RCCPFVtKFn4RsuDuVUB/
	un5VdlHsM9pzi8DTJGiEiJloxY+cisGuFKg/Q=
Message-ID: <daef5be80806231934h259b1222o59577975efdc730a@mail.gmail.com>
Date: Mon, 23 Jun 2008 22:34:51 -0400
From: "P Kapat" <kap4lin@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: adding a user library path..
In-Reply-To: <4989.1214265185@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <daef5be80806231639k73b6d65bs6aefdd7e8f4708a4@mail.gmail.com>
	<4989.1214265185@sss.pgh.pa.us>

Thanks Tom,

On Mon, Jun 23, 2008 at 7:53 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "P Kapat" <kap4lin@gmail.com> 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