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