Skip site navigation (1) Skip section navigation (2)

Re: adding a user library path..

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "P Kapat" <kap4lin(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: adding a user library path..
Date: 2008-06-23 23:53:05
Message-ID: 4989.1214265185@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"P Kapat" <kap4lin(at)gmail(dot)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.

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

In response to

Responses

pgsql-admin by date

Next:From: P KapatDate: 2008-06-24 02:34:51
Subject: Re: adding a user library path..
Previous:From: P KapatDate: 2008-06-23 23:39:52
Subject: adding a user library path..

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group