Re: Segmentation fault - Mailing list pgadmin-support

From Michael Shapiro
Subject Re: Segmentation fault
Date
Msg-id ca3a8da20907081359n237191c5y479abe9a51603b85@mail.gmail.com
Whole thread Raw
In response to Re: Segmentation fault  (Michael Shapiro <mshapiro51@gmail.com>)
Responses Re: Segmentation fault
List pgadmin-support
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.






On Wed, Jul 8, 2009 at 3:04 PM, Guillaume Lelarge <guillaume@lelarge.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.


--


pgadmin-support by date:

Previous
From: Michael Shapiro
Date:
Subject: Re: Segmentation fault
Next
From: Madis Pärn
Date:
Subject: pgadmin goes to infinite loop