Re: preload libraries

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/