pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: flickchick_one <flickchick_one@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: preload libraries
Date: Tue, 22 May 2007 10:22:28 -0700
Message-ID: <465326D4.4070203@commandprompt.com> (raw)
In-Reply-To: <614704.20770.qm@web52109.mail.re2.yahoo.com>
References: <614704.20770.qm@web52109.mail.re2.yahoo.com>

flickchick_one wrote:
> Hello all -
>  
> I'm attempting to preload a shared object file (match.so) in order to 
> create a C function in postgres that use will use it.  To do this, I've 
> added the following line to the postgresql.conf file:

You don't have to preload match.so to use it. Just create the function 
that calls it :)

Joshua D. Drake


>  
> preload_libraries = '/etc/postgresql/8.1/main/match.so'
>  
> Now when attempting to start the server, I receive the following error 
> message:
>  
> Postgresql server failed to start.  Please check the log output:
>  
> Although the message says to check the log for additional info, and a 
> log is created for the event, the file is empty.
>  
> I'm very new to postgres, so I'm wondering if there's some sort of 
> permission problem that I need to address. 
>  
> One note - if I comment out the preload_libraries line, the server 
> starts and runs fine.  But if I then attempt to create the function that 
> calls match.so, the server will crash with the following error message:
>  
> An error has occurred:
> server closed the connection unexpectedly
>           This probably means the server terminated abnormally
>           before or while processing the request.
>  
> Again there are no details in the log to explain what is happening.
>  
> Thanks in advance for any assistance you can provide.
>  
> Chris
>  
>  
> 
> ------------------------------------------------------------------------
> Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge 
> <http://us.rd.yahoo.com/evt=47093/*http://tv.yahoo.com/collections/222>to 
> see what's on, when.


-- 

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/




view thread (4+ messages)  latest in thread

Message-ID: <465326D4.4070203@commandprompt.com>
Permalink:  ../465326D4.4070203@commandprompt.com/
Also on:    postgresql.org/message-id/465326D4.4070203@commandprompt.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: jd@commandprompt.com, flickchick_one@yahoo.com
  Subject: Re: preload libraries
  In-Reply-To: <465326D4.4070203@commandprompt.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox