Обсуждение: 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
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
%
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@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Benjamin Krajmalnik
Sent: Friday, August 04, 2006 12:10 PM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Error installing instrumentation functins on FreeBSD 6.1I 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/libI 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 directoryAny assistance will be appreciated.Regards,Benjamin