From: Ernesto Eduardo Medina Núñez <eemnpg@gmail.com>
To: pgsql-admin@postgresql.org
Subject: server lacks of instrumentation functions in CentOS
Date: Sat, 19 Jul 2008 15:06:46 -0600
Message-ID: <18cc0be90807191406u2a60985o2024f174988bd92b@mail.gmail.com> (raw)
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@postgresql.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@postgresql.org>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: eemnpg@gmail.com
Subject: Re: server lacks of instrumentation functions in CentOS
In-Reply-To: <18cc0be90807191406u2a60985o2024f174988bd92b@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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