X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 69FEA52A67 for ; Thu, 10 Mar 2005 17:52:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03858-05 for ; Thu, 10 Mar 2005 17:52:10 +0000 (GMT) Received: from a.mail.sonic.net (a.mail.sonic.net [64.142.16.245]) by svr1.postgresql.org (Postfix) with ESMTP id 8B91E52A59 for ; Thu, 10 Mar 2005 17:52:09 +0000 (GMT) Received: from cookie.varlena.com (64-142-36-103.dsl.static.sonic.net [64.142.36.103]) by a.mail.sonic.net (8.13.3/8.13.3) with ESMTP id j2AHq7oA013782; Thu, 10 Mar 2005 09:52:07 -0800 Received: by cookie.varlena.com (Postfix, from userid 1000) id 4C14FCCD; Thu, 10 Mar 2005 09:50:10 -0800 (PST) Date: Thu, 10 Mar 2005 09:50:10 -0800 To: Joe Conway Cc: elein , postgresql Subject: Re: Using PL/R with 8.0 Message-ID: <20050310175010.GB5165@varlena.com> Mail-Followup-To: Joe Conway , postgresql References: <20050309033614.GR5165@varlena.com> <4230050F.4000206@joeconway.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4230050F.4000206@joeconway.com> User-Agent: Mutt/1.5.6+20040907i From: elein@varlena.com (elein) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.059 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/32 X-Sequence-Number: 5361 Yahoo! The edit of /etc/ld.so.conf and running ldconfig worked. Thank you. --elein On Thu, Mar 10, 2005 at 12:27:59AM -0800, Joe Conway wrote: > elein wrote: > >I have R_HOME as /usr/lib/R > >libR.so is in /usr/lib/R/lib/libR.so > >and has rw-r--r-- permissions. > > > >/u/local/pgsql80/lib/plr.so is rwxr-xr-x. > > > >I've (re)built pg --with-plr and --with-libs=/usr/lib/R/ (just in case) > > I doubt this does anything useful at best. Postgres has no builtin > support for PL/R. > > > > >When I load plr.sql it complains: > >ERROR: could not load library "/u/local/pgsql80/lib/plr.so": libR.so: > >cannot open shared object file: No such file or directory > > Try either: > export LD_LIBRARY_PATH=/usr/lib/R/lib:$LD_LIBRARY_PATH > as the postgres user (or whatever user owns the cluster) > or edit /etc/ld.so.conf, add /usr/lib/R/lib, run ldconfig. > > Joe >