Re: Error installing instrumentation functins on FreeBSD 6.1

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
%

________________________________

From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Benjamin
Krajmalnik
Sent: Friday, August 04, 2006 12:10 PM
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] Error installing instrumentation
functins on FreeBSD 6.1


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