Skip site navigation (1) Skip section navigation (2)

Re: preload libraries

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: flickchick_one <flickchick_one(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: preload libraries
Date: 2007-05-22 17:22:28
Message-ID: 465326D4.4070203@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-admin
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/


In response to

pgsql-admin by date

Next:From: Chris HooverDate: 2007-05-22 17:25:01
Subject: What happens on a commit?
Previous:From: flickchick_oneDate: 2007-05-22 17:15:51
Subject: preload libraries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group