Re: Segmentation fault

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(at)gmail(dot)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.
>
>
>
>
>
>
> On Wed, Jul 8, 2009 at 3:04 PM, Guillaume Lelarge <guillaume(at)lelarge(dot)info>wrote:
>
>> 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.
>>
>>
>> --
>> Guillaume.
>> http://www.postgresqlfr.org
>> http://dalibo.com
>>
>
>