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 15:18:33 -0700
Message-ID: <48D42539.5040709@frostconsultingllc.com> (raw)
In-Reply-To: <419CB3BB-62B1-41CB-A07F-433A2B0A8999@kevinkempterllc.com>
References: <19FA4E10-429E-49A1-96EB-6BD7F247C88D@kevinkempterllc.com>
<419CB3BB-62B1-41CB-A07F-433A2B0A8999@kevinkempterllc.com>
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
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: <48D42539.5040709@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