Re: Errors installing contrib

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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 916-647-6411 FAX: 916-405-4032