I just tried running the admin81.sql script directly on the server via psql.
I ran it twice - these are the results from the second run:
%psql postgres < admin81.sql
ERROR: could not access file "$libdir/admin81": No such file or directory
ERROR: could not access file "$libdir/admin81": No such file or directory
ERROR: could not access file "$libdir/admin81": No such file or directory
ERROR: function pg_file_rename(text, text, "unknown") does not exist
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
CONTEXT: SQL function "pg_file_rename"
ERROR: could not access file "$libdir/admin81": No such file or directory
ERROR: function "pg_logfile_rotate" already exists with same argument types
ERROR: function "pg_file_read" already exists with same argument types
ERROR: function "pg_file_length" already exists with same argument types
%
I am having some minor issues installing the instrumentation functions on FreeBSD.
I copied th admin81 directory into the contrib folder and modified the Makefile to also read that directory.
So far so good. I do see admin81.so in /usr/local/pgsql/lib
I restarted postgres.
I conncted from a remote windows pgAdmin3.
Connected to template1 (which is where I see the specific functions in pg_catalog on my windows server).
Loaded admin81.sql. Execute it. I am getting the following error:
ERROR: could not access file "$libdir/admin81": No such file or directory
Any assistance will be appreciated.
Regards,
Benjamin
