From: P Kapat <kap4lin@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: adding a user library path..
Date: Mon, 23 Jun 2008 22:34:51 -0400
Message-ID: <daef5be80806231934h259b1222o59577975efdc730a@mail.gmail.com> (raw)
In-Reply-To: <4989.1214265185@sss.pgh.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kap4lin@gmail.com
Subject: Re: adding a user library path..
In-Reply-To: <daef5be80806231934h259b1222o59577975efdc730a@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox