Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A914A6508DE for ; Sat, 19 Jul 2008 18:07:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 63632-05-4 for ; Sat, 19 Jul 2008 18:07:17 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.31]) by postgresql.org (Postfix) with ESMTP id AC2F0650894 for ; Sat, 19 Jul 2008 18:06:47 -0300 (ADT) Received: by yw-out-2324.google.com with SMTP id 3so260483ywj.73 for ; Sat, 19 Jul 2008 14:06:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=T/ix3aYERU0eDWJ1OKRJ5avW6VXzrAvlWkGDm/Q0rfE=; b=q5EUfzifgYRRbf20sBO/DjloptGMib0Si802D9mnQCNR9cPExlTm/Qr0C3ldn+0vHz z7XRqz2ldAYlUjD1P0RHUXVeojCv6zSkhixRUF+qgGALufuN43enmYz9mqnUecQU1+oR 0G2VkoP0qYfuU3s/a68t0S8y0lzAvV20dWLw4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=X5fTebpQaFRsSvprS5gqL9GhXF8Q4Wa4sMZ/rmBrWiKTLEbMzcs0f2Iw6NP3jR0kD0 ANKzJclZJZB3EBdIewyKHPfHz/3Nf0/UOS230REHL7Q4mm1Li7ivDJdR7m37z7I5FUaX D9kttaPKwR4qDktNvjR71wgphkVBIiRONmCKo= Received: by 10.151.106.7 with SMTP id i7mr1790860ybm.176.1216501606066; Sat, 19 Jul 2008 14:06:46 -0700 (PDT) Received: by 10.151.41.7 with HTTP; Sat, 19 Jul 2008 14:06:46 -0700 (PDT) Message-ID: <18cc0be90807191406u2a60985o2024f174988bd92b@mail.gmail.com> Date: Sat, 19 Jul 2008 15:06:46 -0600 From: "=?ISO-8859-1?Q?Ernesto_Eduardo_Medina_N=FA=F1ez?=" To: pgsql-admin@postgresql.org Subject: server lacks of instrumentation functions in CentOS MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_29826_8947817.1216501606078" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200807/173 X-Sequence-Number: 29783 ------=_Part_29826_8947817.1216501606078 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hello when i connect to my database using PgAdmin=B7 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 tha= t I need to load, if there is one...? can you tell me what to do? rpm -qil postgresql-contrib 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 ------=_Part_29826_8947817.1216501606078 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
Hello when i connect to my database using PgAdmin=B7 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 distr= ibution 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

Name   &nb= sp;    : postgresql-contrib     &nb= sp;     Relocations: (not relocatable)
Version =     : 8.1.11        =             &nb= sp;       Vendor: CentOS
Release &nbs= p;   : 1.el5_1.1        &= nbsp;            Bui= ld 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       : Applic= ations/Databases        Source RPM: post= gresql-8.1.11-1.el5_1.1.src.rpm
Size      =   : 1159682          = ;            &n= bsp;   License: BSD
Signature   : DSA/SHA1, Sat 12 Jan 2008 08:50:36 PM MST, Key ID a= 8a447dce8562897
URL         : ht= tp://www.postgresql.org/
Summary     : Contributed s= ource and binaries distributed with PostgreSQL
Description :
The postgresql-contrib package contains contributed packages that are
in= cluded 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/isb= n_issn.so
/usr/lib/pgsql/lo.so
/usr/lib/pgsql/ltree.so
/usr/lib/pg= sql/moddatetime.so
/usr/lib/pgsql/pending.so
/usr/lib/pgsql/pg_buffercache.so
/usr/lib/p= gsql/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/pgsq= l/seg.so
/usr/lib/pgsql/tablefunc.so
/usr/lib/pgsql/timetravel.so
/usr/lib/pgs= ql/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.adddepen= d
/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-c= ontrib-8.1.11/README.chkpass
/usr/share/doc/postgresql-contrib-8.1.11/RE= ADME.cube
/usr/share/doc/postgresql-contrib-8.1.11/README.dbf2pg
/usr/share/doc/po= stgresql-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.e= arthdistance
/usr/share/doc/postgresql-contrib-8.1.11/README.fti
/usr/share/doc/postg= resql-contrib-8.1.11/README.fuzzystrmatch
/usr/share/doc/postgresql-cont= rib-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/po= stgresql-contrib-8.1.11/README.oid2name
/usr/share/doc/postgresql-contri= b-8.1.11/README.ora2pg
/usr/share/doc/postgresql-contrib-8.1.11/README.p= g_buffercache
/usr/share/doc/postgresql-contrib-8.1.11/README.pg_trgm
/usr/share/doc/p= ostgresql-contrib-8.1.11/README.pgbench
/usr/share/doc/postgresql-contri= b-8.1.11/README.pgbench_jis
/usr/share/doc/postgresql-contrib-8.1.11/REA= DME.pgcrypto
/usr/share/doc/postgresql-contrib-8.1.11/README.pgstattuple
/usr/share/d= oc/postgresql-contrib-8.1.11/README.pgstattuple.euc_jp
/usr/share/doc/po= stgresql-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/postg= resql-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/do= c/postgresql-contrib-8.1.11/README.vacuumlo
/usr/share/doc/postgresql-co= ntrib-8.1.11/README.xml2
/usr/share/doc/postgresql-contrib-8.1.11/autoin= c.example
/usr/share/doc/postgresql-contrib-8.1.11/insert_username.example
/usr/sh= are/doc/postgresql-contrib-8.1.11/moddatetime.example
/usr/share/doc/pos= tgresql-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_gi= st.sql
/usr/share/pgsql/contrib/chkpass.sql
/usr/share/pgsql/contrib/cube.sql/usr/share/pgsql/contrib/dblink.sql
/usr/share/pgsql/contrib/earthdist= ance.sql
/usr/share/pgsql/contrib/english.stop
/usr/share/pgsql/contr= ib/fti.sql
/usr/share/pgsql/contrib/fuzzystrmatch.sql
/usr/share/pgsql/contrib/inse= rt_username.sql
/usr/share/pgsql/contrib/int_aggregate.sql
/usr/share= /pgsql/contrib/isbn_issn.sql
/usr/share/pgsql/contrib/lo.sql
/usr/sha= re/pgsql/contrib/lo_drop.sql
/usr/share/pgsql/contrib/lo_test.sql
/usr/share/pgsql/contrib/ltree.sql<= br>/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/russ= ian.stop
/usr/share/pgsql/contrib/seg.sql
/usr/share/pgsql/contrib/sl= aveDatabase.conf
/usr/share/pgsql/contrib/tablefunc.sql
/usr/share/pgsql/contrib/timetrav= el.sql
/usr/share/pgsql/contrib/tsearch2.sql
/usr/share/pgsql/contrib= /untsearch2.sql
/usr/share/pgsql/contrib/user_locks.sql
------=_Part_29826_8947817.1216501606078--