pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedErrors installing contrib
5+ messages / 2 participants
[nested] [flat]
* Errors installing contrib
@ 2008-09-19 21:51 kevin kempter <kevin@kevinkempterllc.com>
0 siblings, 1 reply; 5+ messages in thread
From: kevin kempter @ 2008-09-19 21:51 UTC (permalink / raw)
To: pgsql-admin
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...
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Errors installing contrib
@ 2008-09-19 22:14 kevin kempter <kevin@kevinkempterllc.com>
parent: kevin kempter <kevin@kevinkempterllc.com>
0 siblings, 1 reply; 5+ messages in thread
From: kevin kempter @ 2008-09-19 22:14 UTC (permalink / raw)
To: pgsql-admin
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
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...
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Errors installing contrib
@ 2008-09-19 22:18 Jeff Frost <jeff@frostconsultingllc.com>
parent: kevin kempter <kevin@kevinkempterllc.com>
0 siblings, 1 reply; 5+ messages in thread
From: Jeff Frost @ 2008-09-19 22:18 UTC (permalink / raw)
To: kevin kempter <kevin@kevinkempterllc.com>; +Cc: 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@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 916-647-6411 FAX: 916-405-4032
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Errors installing contrib
@ 2008-09-19 22:52 kevin kempter <kevin@kevinkempterllc.com>
parent: Jeff Frost <jeff@frostconsultingllc.com>
0 siblings, 1 reply; 5+ messages in thread
From: kevin kempter @ 2008-09-19 22:52 UTC (permalink / raw)
To: Jeff Frost <jeff@frostconsultingllc.com>; +Cc: pgsql-admin
On Sep 19, 2008, at 4:18 PM, Jeff Frost wrote:
> 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.
>
Looks like they have both. there are postgres binaries in /usr/bin
tied to 8.1.4 RPM's. There are also binaries in /pg825/bin tied to a
postgres 8.2.5 source install.
In either case I get the same error
I go to /usr/share/pgsql/contrib installed by the postgresql-
contrib-8.1.4-1.1 rpm and run /usr/bin/psql -f pg_buffercache.sql
<dbname>
I also tried goint to the src tree in the contrib/pg_buffercache dir
and running this:
export PATH=/pg825/bin
make (as postgres)
make install (as root)
/pg825/bin/psql -f pg_buffercache.sql <dbname>
also
/usr/bin/pg_config --libdir shows me /usr/lib64
/pg825/bin/pg_config --libdir shows me /disk1/pg825/lib
I even tried placing the pg_buffercache.so.* files from the src build
in the lib dirs:
/usr/lib64
/disk1/pg825/lib
/disk1/pg825/lib/postgresql
and I still got the same error
Thoughts ?
>> 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Errors installing contrib
@ 2008-09-19 23:04 Jeff Frost <jeff@frostconsultingllc.com>
parent: kevin kempter <kevin@kevinkempterllc.com>
0 siblings, 0 replies; 5+ messages in thread
From: Jeff Frost @ 2008-09-19 23:04 UTC (permalink / raw)
To: kevin kempter <kevin@kevinkempterllc.com>; +Cc: pgsql-admin
>>>
>>> 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.
>>
> Looks like they have both. there are postgres binaries in /usr/bin
> tied to 8.1.4 RPM's. There are also binaries in /pg825/bin tied to a
> postgres 8.2.5 source install.
>
> In either case I get the same error
>
> I go to /usr/share/pgsql/contrib installed by
> the postgresql-contrib-8.1.4-1.1 rpm and run /usr/bin/psql -f
> pg_buffercache.sql <dbname>
>
> I also tried goint to the src tree in the contrib/pg_buffercache dir
> and running this:
> export PATH=/pg825/bin
> make (as postgres)
> make install (as root)
> /pg825/bin/psql -f pg_buffercache.sql <dbname>
>
>
> also
> /usr/bin/pg_config --libdir shows me /usr/lib64
>
> /pg825/bin/pg_config --libdir shows me /disk1/pg825/lib
>
>
> I even tried placing the pg_buffercache.so.* files from the src build
> in the lib dirs:
> /usr/lib64
> /disk1/pg825/lib
> /disk1/pg825/lib/postgresql
>
> and I still got the same error
>
>
> Thoughts ?
>
>
Look for one of the standard libs like: plpgsql.so to see where the
running postgresql's lib dir might be. You can also start up psql and
issue:
show dynamic_library_path ;
to see if it's says anything other than $libdir.
Probably worthwhile to also do a 'show config_file;' to see which
postgresql.conf the running server is using.
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 916-647-6411 FAX: 916-405-4032
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2008-09-19 23:04 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-19 21:51 Errors installing contrib kevin kempter <kevin@kevinkempterllc.com>
2008-09-19 22:14 ` kevin kempter <kevin@kevinkempterllc.com>
2008-09-19 22:18 ` Jeff Frost <jeff@frostconsultingllc.com>
2008-09-19 22:52 ` kevin kempter <kevin@kevinkempterllc.com>
2008-09-19 23:04 ` Jeff Frost <jeff@frostconsultingllc.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox