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/
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