I don't think this is really a PgAdmin problem. PgAdmin is running the postgres function pg_logdir_ls()
which is defined (on my server) as:
CREATE OR REPLACE FUNCTION pg_logdir_ls()
RETURNS SETOF record AS
'$libdir/admin81', 'pg_logdir_ls'
LANGUAGE 'c' VOLATILE STRICT;
So there is some interaction between the C function and the system involving $libdir/admin81.
Since I don't understand where this function came from (if it isn't part of the server), or why it is looking for admin81
I will ask the admin of the server to look into this ...
On Wed, Jul 8, 2009 at 3:45 PM, Michael Shapiro
<mshapiro51@gmail.com> wrote:
PostgreSQL 8.1.9 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-58)
I am not the admin that installs or runs the server. This server (and the others below) are at another institution.
Le mercredi 8 juillet 2009 à 16:09:15, Michael Shapiro a écrit :
> The query
> select count(*) from pg_proc where proname='pg_file_write';
> returns 1
>
Which release of PostgreSQL are you using? Did you change it? (I'm thinking
about a 8.1 to something upgrade). Because the error message says you don't
have $libdir/admin81.so (or .dll on Windows) installed on your server. I see two ways to get such an error: someone removed or renamed $libdir/admin81.so
or someone upgraded the PostgreSQL server.
--