Re: Error installing instrumentation functins on FreeBSD 6.1

["Benjamin Krajmalnik" <kraj(at)illumen(dot)com>]

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