Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 1EB5864FC00
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Fri, 19 Sep 2008 20:05:40 -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 73599-02 for <pgsql-admin-postgresql.org@postgresql.org>;
	Fri, 19 Sep 2008 20:05:37 -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 2AE2E64FC02
	for <pgsql-admin@postgresql.org>; Fri, 19 Sep 2008 20:05:36 -0300 (ADT)
Received: from asav-1.01.com (localhost.localdomain [127.0.0.1])
	by asav-1.01.com (8.13.1/8.13.1) with SMTP id m8JN5RHt000653;
	Fri, 19 Sep 2008 18:05:27 -0500
Received: from smtp-2.01.com (smtp-2.01.com [38.98.186.158])
	by asav-1.01.com (asav-1.01.com [10.25.1.11])
	id k8II5R0518652424DO ret-id none; Fri, 19 Sep 2008 18:05:27 -0500
Received: from localhost (localhost.localdomain [127.0.0.1])
	by smtp-2.01.com (Postfix) with ESMTP id 492761AD587;
	Fri, 19 Sep 2008 18:05:27 -0500 (CDT)
Received: from smtp-2.01.com ([127.0.0.1])
	by localhost (smtp-2.01.com [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id gB8m9NJAcuDF; Fri, 19 Sep 2008 18:05:27 -0500 (CDT)
Received: from [10.10.10.18] (8.202-62-69.ftth.swbr.surewest.net
 [69.62.202.8])
	by smtp-2.01.com (Postfix) with ESMTP id E703A1AD41C;
	Fri, 19 Sep 2008 18:05:26 -0500 (CDT)
Message-ID: <48D4301A.8030003@frostconsultingllc.com>
Date: Fri, 19 Sep 2008 16:04:58 -0700
From: Jeff Frost <jeff@frostconsultingllc.com>
Organization: Frost Consulting, LLC
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
To: kevin kempter <kevin@kevinkempterllc.com>
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>
	<48D42539.5040709@frostconsultingllc.com>
	<EBEF81AF-C802-4607-BB85-651F5600A444@kevinkempterllc.com>
In-Reply-To: <EBEF81AF-C802-4607-BB85-651F5600A444@kevinkempterllc.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
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=2.543 tagged_above=0 required=5 tests=URI_NOVOWEL=2.543
X-Spam-Level: **
X-Archive-Number: 200809/223
X-Sequence-Number: 30316


>>>
>>> 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.
>>
> Looks like they have both. there are postgres binaries in /usr/bin
> tied to 8.1.4 RPM's. There are also binaries in /pg825/bin tied to a
> postgres 8.2.5 source install. 
>
> In either case I get the same error
>
> I go to /usr/share/pgsql/contrib installed by
> the postgresql-contrib-8.1.4-1.1 rpm and run /usr/bin/psql -f
> pg_buffercache.sql <dbname>
>
> I also tried goint to the src tree in the contrib/pg_buffercache dir
> and running this:
> export PATH=/pg825/bin
> make (as postgres)
> make install (as root)
> /pg825/bin/psql -f pg_buffercache.sql <dbname>
>
>
> also
> /usr/bin/pg_config --libdir shows me /usr/lib64
>
> /pg825/bin/pg_config --libdir shows me /disk1/pg825/lib
>
>
> I even tried placing the pg_buffercache.so.* files from the src build
> in the lib dirs:
> /usr/lib64
> /disk1/pg825/lib
> /disk1/pg825/lib/postgresql
>
> and I still got the same error
>
>
> Thoughts ?
>
>
Look for one of the standard libs like: plpgsql.so to see where the
running postgresql's lib dir might be.  You can also start up psql and
issue:

show dynamic_library_path ;

to see if it's says anything other than $libdir.

Probably worthwhile to also do a 'show config_file;' to see which
postgresql.conf the running server is using.


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