From: | "Benjamin Krajmalnik" <kraj(at)illumen(dot)com> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Error installing instrumentation functins on FreeBSD 6.1 |
Date: | 2006-08-05 22:30:58 |
Message-ID: | BF337097BDD9D849A2F4B818DDB27987252592@stash.stackdump.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Darius Lovehall | 2006-08-06 23:12:20 | reconnecting sql query window after server restart |
Previous Message | Devrim GUNDUZ | 2006-08-04 22:48:50 | Re: pgadmin3 on CentOS |