Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 29ED36516A3 for ; Mon, 23 Jun 2008 20:40:01 -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 90460-07 for ; Mon, 23 Jun 2008 20:39:49 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.169]) by postgresql.org (Postfix) with ESMTP id 8F69B6515F7 for ; Mon, 23 Jun 2008 20:39:53 -0300 (ADT) Received: by wf-out-1314.google.com with SMTP id 25so2366129wfc.28 for ; Mon, 23 Jun 2008 16:39:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type:content-transfer-encoding :content-disposition; bh=GxsAixgNzmBbSmC3f0uMpR2cScEoMUEl7H9l1n2Fsl0=; b=ME5HSgSI/1vhDbrsW1vr/ON6xY0FdNIjgizotS986yyg37RsElIDo6E/5ZVAmECiEc TjoWnV/zwuzjKhLPcA5LMEPf81t240usdAhD5mMkBhP+WxrDs/s9A3M6JC+MDL946KPR MQQ+ci1sXoK5SU+H9aNny6AJBxwO/AH7jIGbU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type :content-transfer-encoding:content-disposition; b=crXOxaH6DV8FdAFCui081g3QqVYXKiiCaIeXtS6OwbvF4uyFK+IWO+ur/nwwzVzdmL 36l9wXgOcwfqGJdrzw9e7eiudX8PteZ5BJmHF7SjX5KPplNByI00rUPj2ynsis9MZwcp bbiT30XjfOC2WYGj/4xOX1E6K7mdtxzgO+Pd4= Received: by 10.143.30.10 with SMTP id h10mr4753960wfj.7.1214264392109; Mon, 23 Jun 2008 16:39:52 -0700 (PDT) Received: by 10.150.138.19 with HTTP; Mon, 23 Jun 2008 16:39:52 -0700 (PDT) Message-ID: Date: Mon, 23 Jun 2008 19:39:52 -0400 From: "P Kapat" To: pgsql-admin@postgresql.org Subject: adding a user library path.. MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200806/198 X-Sequence-Number: 29536 Hi, I am working on a RHEL 5 box where I do not have any administrative access. But if need be, I can request the administrator to do some changes. Currently the following packages are installed on the box: postgresql.i386, postgresql-contrib.i386, postgresql-devel.i386, postgresql-docs.i386, postgresql-libs.i386, postgresql-pl.i386, postgresql-python.i386, postgresql-server.i386; all at version 8.1.11-1.el5_1.1. I have successfully (i think) compiled proj4.6, geos-3.0.0, and postgis and "installed" them under $HOME (with proper $LD_LIBRARY_PATH). But postgres server is not aware of this path. How do I rectify this? pg_config shows the following (among other parameters): BINDIR = /usr/bin INCLUDEDIR = /usr/include PKGINCLUDEDIR = /usr/include/pgsql INCLUDEDIR-SERVER = /usr/include/pgsql/server LIBDIR = /usr/lib PKGLIBDIR = /usr/lib/pgsql SHAREDIR = /usr/share/pgsql SYSCONFDIR = /etc/sysconfig/pgsql 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? Again, a userland solution will be helpful unless an administrator's access is unavoidable! Thanks in advance, -- Regards PK -------------------------------------- http://counter.li.org #402424