Skip site navigation (1) Skip section navigation (2)

Re: Errors installing contrib

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: kevin kempter <kevin(at)kevinkempterllc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Errors installing contrib
Date: 2008-09-19 22:18:33
Message-ID: 48D42539.5040709@frostconsultingllc.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

Responses

pgsql-admin by date

Next:From: kevin kempterDate: 2008-09-19 22:52:12
Subject: Re: Errors installing contrib
Previous:From: kevin kempterDate: 2008-09-19 22:14:21
Subject: Re: Errors installing contrib

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group