From: Jeff Frost <jeff@frostconsultingllc.com>
To: kevin kempter <kevin@kevinkempterllc.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Errors installing contrib
Date: Fri, 19 Sep 2008 16:04:58 -0700
Message-ID: <48D4301A.8030003@frostconsultingllc.com> (raw)
In-Reply-To: <EBEF81AF-C802-4607-BB85-651F5600A444@kevinkempterllc.com>
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>
>>>
>>> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jeff@frostconsultingllc.com, kevin@kevinkempterllc.com
Subject: Re: Errors installing contrib
In-Reply-To: <48D4301A.8030003@frostconsultingllc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox