Re: Errors installing contrib

[Jeff Frost <jeff@xxxxxxxxxxxxxxxxxxxxxx>]

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