Re: Segmentation fault - Mailing list pgadmin-support

From Michael Shapiro
Subject Re: Segmentation fault
Date
Msg-id ca3a8da20907080709p486e2757n855634147d0d75fc@mail.gmail.com
Whole thread Raw
In response to Re: Segmentation fault  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: Segmentation fault
List pgadmin-support
The query
select count(*) from pg_proc where proname='pg_file_write';
returns 1

On Wed, Jul 8, 2009 at 1:42 AM, Guillaume Lelarge <guillaume@lelarge.info> wrote:
Le mardi 7 juillet 2009 à 23:47:18, Michael Shapiro a écrit :
> I have no idea. Would this be part of the postgres server or part of
> PgAdmin?
>

The adminpack is a contrib module. You need to install it on the server for
pgAdmin to use it. It adds a few functions, like pg_file_write that pgAdmin
needs to be able to write on the config file.

To check if you have this module installed, the simplest thing to do is to
check if pg_file_write function exists. The SQL query should tell you how many
pg_file_write() function you have:

select count(*) from pg_proc where proname='pg_file_write';

0 meaning that you don't have this function.


--

pgadmin-support by date:

Previous
From: Pedro Doria Meunier
Date:
Subject: Re: Segmentation fault
Next
From: Guillaume Lelarge
Date:
Subject: Re: Segmentation fault