I have a PostgreSQL 8.3.3 database running on a linux system. I
followed the instructions and built and installed the adminpack.so
library.
I ran the adminpack.sql commands, stopped and started the database but the
pgadmin Client tells me 'The server lacks instrumentation functions' when
I try to use Server Status
I can see that the functions are defined in the database
pg_catalog | pg_file_read | text | text, bigint, bigintpg_catalog
|pg_file_rename | boolean | text, textpg_catalog | pg_file_rename
| boolean | text, text, textpg_catalog | pg_file_unlink
| boolean | textpg_catalog | pg_file_write | bigint
| text, text, boolean
pg_catalog | pg_logfile_rotate | integer
What else do I need to do?
I followed the instructions in the dialog
PostgreSQL 8.2 and above include the instrumentation functions in the "adminpack" contrib module. After the module is
installed,you need to create the instrumentation functions in your maintenance database using the admin.sql script
(admin81.sqlfor PostgreSQL 8.1) which are usually located in the pgsql share directory (e.g. /usr/local/pgsql/share)
I don't see anything useful in the log file so I am not sure how to
debug why it thinks that the functions aren't there.
--
Eric M. Boehm /"\ ASCII Ribbon Campaign
boehm@nortel.com \ / No HTML or RTF in mail X No proprietary
word-processing
Respect Open Standards / \ files in mail