Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id DC41F64FC03 for ; Fri, 19 Sep 2008 19:19:42 -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 57167-07 for ; Fri, 19 Sep 2008 19:19:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp.01.com (lb-2.01.com [38.98.186.147]) by postgresql.org (Postfix) with ESMTP id CE09364FC01 for ; Fri, 19 Sep 2008 19:19:39 -0300 (ADT) Received: from asav-2.01.com (localhost.localdomain [127.0.0.1]) by asav-2.01.com (8.13.1/8.13.1) with SMTP id m8JMJDKk010392; Fri, 19 Sep 2008 17:19:13 -0500 Received: from smtp-1.01.com (smtp-1.01.com [38.98.186.157]) by asav-2.01.com (asav-2.01.com [10.25.1.12]) id k8IHJD2278850359XE ret-id none; Fri, 19 Sep 2008 17:19:13 -0500 Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp-1.01.com (Postfix) with ESMTP id 585C0E1375; Fri, 19 Sep 2008 17:19:13 -0500 (CDT) Received: from smtp-1.01.com ([127.0.0.1]) by localhost (smtp-1.01.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id r-UPZ85YbgVW; Fri, 19 Sep 2008 17:19:13 -0500 (CDT) Received: from [10.10.10.5] (8.202-62-69.ftth.swbr.surewest.net [69.62.202.8]) by smtp-1.01.com (Postfix) with ESMTP id 03E33E08EE; Fri, 19 Sep 2008 17:19:12 -0500 (CDT) Message-ID: <48D42539.5040709@frostconsultingllc.com> Date: Fri, 19 Sep 2008 15:18:33 -0700 From: Jeff Frost Organization: Frost Consulting, LLC User-Agent: Thunderbird 2.0.0.16 (X11/20080723) MIME-Version: 1.0 To: kevin kempter CC: pgsql-admin@postgresql.org Subject: Re: Errors installing contrib References: <19FA4E10-429E-49A1-96EB-6BD7F247C88D@kevinkempterllc.com> <419CB3BB-62B1-41CB-A07F-433A2B0A8999@kevinkempterllc.com> In-Reply-To: <419CB3BB-62B1-41CB-A07F-433A2B0A8999@kevinkempterllc.com> X-Enigmail-Version: 0.95.6 Content-Type: multipart/alternative; boundary="------------030601040408060201040804" X-FSL-MailScanner-Information: Please contact postmaster@01.com for more information X-FSL-MailScanner: Found to be clean X-FSL-MailScanner-SpamCheck: X-FSL-MailScanner-From: jeff@frostconsultingllc.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200809/221 X-Sequence-Number: 30314 This is a multi-part message in MIME format. --------------030601040408060201040804 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit kevin kempter wrote: > ok so I have more info. > > > a pg_config --libdir shows me /usr/lib64 > > however the make install installs the pg_buffercache > in /pgmoveable/lib/postgresql > > How was postgresql installed on the machine in the first place? RPM? DEB? Just guessing by the pg_config output, I'd say postgresql was installed on the server via some package management and you also have a separately compiled source tree? If you installed from package management, there usually is a contrib package which contains pg_buffercache as well as the other normal contrib modules. > Thoughts ? > > > > On Sep 19, 2008, at 3:51 PM, kevin kempter wrote: > >> Hi All; >> >> I've gone into contribs/pg_buffercache and run this: >> >> make (as postgres) >> make install (as root) >> psql -f pg_buffercache.sql >> >> when I run the psql command against my database I get this: >> >> BEGIN >> SET >> psql:pg_buffercache.sql:9: ERROR: could not access file >> "$libdir/pg_buffercache": No such file or directory >> psql:pg_buffercache.sql:15: ERROR: current transaction is aborted, >> commands ignored until end of transaction block >> psql:pg_buffercache.sql:18: ERROR: current transaction is aborted, >> commands ignored until end of transaction block >> psql:pg_buffercache.sql:19: ERROR: current transaction is aborted, >> commands ignored until end of transaction block >> ROLLBACK >> >> >> >> Any thoughts ? >> >> >> Thanks in advance... >> >> > -- Jeff Frost, Owner Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 916-647-6411 FAX: 916-405-4032 --------------030601040408060201040804 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit kevin kempter wrote:
ok so I have more info.


a pg_config --libdir shows me /usr/lib64

however the make install installs the pg_buffercache in /pgmoveable/lib/postgresql



How was postgresql installed on the machine in the first place?  RPM? DEB?  Just guessing by the pg_config output, I'd say postgresql was installed on the server via some package management and you also have a separately compiled source tree?  If you installed from package management, there usually is a contrib package which contains pg_buffercache as well as the other normal contrib modules.

Thoughts ?



On Sep 19, 2008, at 3:51 PM, kevin kempter wrote:

Hi All;

I've gone into contribs/pg_buffercache and run this:

make (as postgres)
make install (as root)
psql -f pg_buffercache.sql <my_db>

when I run the psql command against my database I get this:

BEGIN
SET
psql:pg_buffercache.sql:9: ERROR:  could not access file "$libdir/pg_buffercache": No such file or directory
psql:pg_buffercache.sql:15: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:pg_buffercache.sql:18: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:pg_buffercache.sql:19: ERROR:  current transaction is aborted, commands ignored until end of transaction block
ROLLBACK



Any thoughts ?


Thanks in advance...




-- 
Jeff Frost, Owner 	<jeff@frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 916-647-6411	FAX: 916-405-4032
--------------030601040408060201040804--