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

server lacks of instrumentation functions in CentOS

From: Ernesto Eduardo Medina Núñez <eemnpg(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: server lacks of instrumentation functions in CentOS
Date: 2008-07-19 21:06:46
Message-ID: 18cc0be90807191406u2a60985o2024f174988bd92b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hello when i connect to my database using PgAdmin· I get this message:
Server lacks of instrumentation functions.

I know That i need to run the admin81.sql script, but I don't know if my
distribution has compiled postgresql to support that functions.
I installed the postgresql-contrib, but I don't know what is the module that
I need to load, if there is one...?
can you tell me what to do?

 rpm -qil postgresql-contrib <pgsql-admin(at)postgresql(dot)org>

Name        : postgresql-contrib           Relocations: (not relocatable)
Version     : 8.1.11                            Vendor: CentOS
Release     : 1.el5_1.1                     Build Date: Sat 12 Jan 2008
07:45:09 AM MST
Install Date: Sat 19 Jul 2008 01:03:04 PM MDT      Build Host: builder6
Group       : Applications/Databases        Source RPM:
postgresql-8.1.11-1.el5_1.1.src.rpm
Size        : 1159682                          License: BSD
Signature   : DSA/SHA1, Sat 12 Jan 2008 08:50:36 PM MST, Key ID
a8a447dce8562897
URL         : http://www.postgresql.org/
Summary     : Contributed source and binaries distributed with PostgreSQL
Description :
The postgresql-contrib package contains contributed packages that are
included in the PostgreSQL distribution.
/usr/bin/DBMirror.pl
/usr/bin/clean_pending.pl
/usr/bin/dbf2pg
/usr/bin/fti.pl
/usr/bin/oid2name
/usr/bin/pgbench
/usr/bin/vacuumlo
/usr/lib/pgsql/_int.so
/usr/lib/pgsql/autoinc.so
/usr/lib/pgsql/btree_gist.so
/usr/lib/pgsql/chkpass.so
/usr/lib/pgsql/cube.so
/usr/lib/pgsql/dblink.so
/usr/lib/pgsql/earthdistance.so
/usr/lib/pgsql/fti.so
/usr/lib/pgsql/fuzzystrmatch.so
/usr/lib/pgsql/insert_username.so
/usr/lib/pgsql/int_aggregate.so
/usr/lib/pgsql/isbn_issn.so
/usr/lib/pgsql/lo.so
/usr/lib/pgsql/ltree.so
/usr/lib/pgsql/moddatetime.so
/usr/lib/pgsql/pending.so
/usr/lib/pgsql/pg_buffercache.so
/usr/lib/pgsql/pg_trgm.so
/usr/lib/pgsql/pgcrypto.so
/usr/lib/pgsql/pgstattuple.so
/usr/lib/pgsql/pgxml.so
/usr/lib/pgsql/refint.so
/usr/lib/pgsql/seg.so
/usr/lib/pgsql/tablefunc.so
/usr/lib/pgsql/timetravel.so
/usr/lib/pgsql/tsearch2.so
/usr/lib/pgsql/user_locks.so
/usr/share/doc/postgresql-contrib-8.1.11
/usr/share/doc/postgresql-contrib-8.1.11/README.adddepend
/usr/share/doc/postgresql-contrib-8.1.11/README.apachelog
/usr/share/doc/postgresql-contrib-8.1.11/README.btree_gist
/usr/share/doc/postgresql-contrib-8.1.11/README.chkpass
/usr/share/doc/postgresql-contrib-8.1.11/README.cube
/usr/share/doc/postgresql-contrib-8.1.11/README.dbf2pg
/usr/share/doc/postgresql-contrib-8.1.11/README.dblink
/usr/share/doc/postgresql-contrib-8.1.11/README.dbmirror
/usr/share/doc/postgresql-contrib-8.1.11/README.earthdistance
/usr/share/doc/postgresql-contrib-8.1.11/README.fti
/usr/share/doc/postgresql-contrib-8.1.11/README.fuzzystrmatch
/usr/share/doc/postgresql-contrib-8.1.11/README.int_aggregate
/usr/share/doc/postgresql-contrib-8.1.11/README.intarray
/usr/share/doc/postgresql-contrib-8.1.11/README.isbn_issn
/usr/share/doc/postgresql-contrib-8.1.11/README.lo
/usr/share/doc/postgresql-contrib-8.1.11/README.ltree
/usr/share/doc/postgresql-contrib-8.1.11/README.mac
/usr/share/doc/postgresql-contrib-8.1.11/README.mpgsql
/usr/share/doc/postgresql-contrib-8.1.11/README.oid2name
/usr/share/doc/postgresql-contrib-8.1.11/README.ora2pg
/usr/share/doc/postgresql-contrib-8.1.11/README.pg_buffercache
/usr/share/doc/postgresql-contrib-8.1.11/README.pg_trgm
/usr/share/doc/postgresql-contrib-8.1.11/README.pgbench
/usr/share/doc/postgresql-contrib-8.1.11/README.pgbench_jis
/usr/share/doc/postgresql-contrib-8.1.11/README.pgcrypto
/usr/share/doc/postgresql-contrib-8.1.11/README.pgstattuple
/usr/share/doc/postgresql-contrib-8.1.11/README.pgstattuple.euc_jp
/usr/share/doc/postgresql-contrib-8.1.11/README.seg
/usr/share/doc/postgresql-contrib-8.1.11/README.soundex
/usr/share/doc/postgresql-contrib-8.1.11/README.spi
/usr/share/doc/postgresql-contrib-8.1.11/README.tablefunc
/usr/share/doc/postgresql-contrib-8.1.11/README.timetravel
/usr/share/doc/postgresql-contrib-8.1.11/README.tsearch2
/usr/share/doc/postgresql-contrib-8.1.11/README.user_locks
/usr/share/doc/postgresql-contrib-8.1.11/README.vacuumlo
/usr/share/doc/postgresql-contrib-8.1.11/README.xml2
/usr/share/doc/postgresql-contrib-8.1.11/autoinc.example
/usr/share/doc/postgresql-contrib-8.1.11/insert_username.example
/usr/share/doc/postgresql-contrib-8.1.11/moddatetime.example
/usr/share/doc/postgresql-contrib-8.1.11/refint.example
/usr/share/doc/postgresql-contrib-8.1.11/timetravel.example
/usr/share/pgsql/contrib
/usr/share/pgsql/contrib/AddTrigger.sql
/usr/share/pgsql/contrib/MirrorSetup.sql
/usr/share/pgsql/contrib/_int.sql
/usr/share/pgsql/contrib/autoinc.sql
/usr/share/pgsql/contrib/btree_gist.sql
/usr/share/pgsql/contrib/chkpass.sql
/usr/share/pgsql/contrib/cube.sql
/usr/share/pgsql/contrib/dblink.sql
/usr/share/pgsql/contrib/earthdistance.sql
/usr/share/pgsql/contrib/english.stop
/usr/share/pgsql/contrib/fti.sql
/usr/share/pgsql/contrib/fuzzystrmatch.sql
/usr/share/pgsql/contrib/insert_username.sql
/usr/share/pgsql/contrib/int_aggregate.sql
/usr/share/pgsql/contrib/isbn_issn.sql
/usr/share/pgsql/contrib/lo.sql
/usr/share/pgsql/contrib/lo_drop.sql
/usr/share/pgsql/contrib/lo_test.sql
/usr/share/pgsql/contrib/ltree.sql
/usr/share/pgsql/contrib/moddatetime.sql
/usr/share/pgsql/contrib/pg_buffercache.sql
/usr/share/pgsql/contrib/pg_trgm.sql
/usr/share/pgsql/contrib/pgcrypto.sql
/usr/share/pgsql/contrib/pgstattuple.sql
/usr/share/pgsql/contrib/pgxml.sql
/usr/share/pgsql/contrib/refint.sql
/usr/share/pgsql/contrib/russian.stop
/usr/share/pgsql/contrib/seg.sql
/usr/share/pgsql/contrib/slaveDatabase.conf
/usr/share/pgsql/contrib/tablefunc.sql
/usr/share/pgsql/contrib/timetravel.sql
/usr/share/pgsql/contrib/tsearch2.sql
/usr/share/pgsql/contrib/untsearch2.sql
/usr/share/pgsql/contrib/user_locks.sql
<pgsql-admin(at)postgresql(dot)org>

Responses

pgsql-admin by date

Next:From: Daniel J. SummersDate: 2008-07-20 02:47:30
Subject: Created non-owner user cannot see database
Previous:From: paul sochaDate: 2008-07-19 15:37:24
Subject: Re: Database Link

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