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