Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 20955651767 for ; Tue, 24 Jun 2008 00:23:45 -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 98031-06-2 for ; Tue, 24 Jun 2008 00:23:08 -0300 (ADT) Received: from mx3.hub.org (mx3.hub.org [206.223.169.73]) by postgresql.org (Postfix) with ESMTP id E9E83651734 for ; Tue, 24 Jun 2008 00:15:35 -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 mx3.hub.org (Postfix) with ESMTP id 1478137B7A3 for ; Tue, 24 Jun 2008 00:15:35 -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 m5O33mDq007755; Mon, 23 Jun 2008 23:03:49 -0400 (EDT) To: "P Kapat" cc: pgsql-admin@postgresql.org Subject: Re: adding a user library path.. In-reply-to: References: <4989.1214265185@sss.pgh.pa.us> Comments: In-reply-to "P Kapat" message dated "Mon, 23 Jun 2008 22:34:51 -0400" Date: Mon, 23 Jun 2008 23:03:48 -0400 Message-ID: <7754.1214276628@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/201 X-Sequence-Number: 29539 "P Kapat" writes: > 1. How should the admin go about adding $HOME/usr/local/lib to $PKGLIBDIR? You don't. You can try editing the SQL CREATE FUNCTION commands as I suggested before. If that doesn't work because of SELinux, you'll need to get the admin to drop the shlibs into a directory that SELinux will let Postgres load shlibs from. Frankly, there's going to be zero interest in any proposal to make this more flexible, because making it more flexible means opening a truck-sized security hole. We don't *want* Postgres loading code from random places. regards, tom lane