Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id B969E9FBA76 for ; Tue, 22 May 2007 14:22:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 23976-02 for ; Tue, 22 May 2007 14:22:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id B1D719FBB63 for ; Tue, 22 May 2007 14:21:49 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l4MHLonk016714; Tue, 22 May 2007 10:21:50 -0700 Message-ID: <465326D4.4070203@commandprompt.com> Date: Tue, 22 May 2007 10:22:28 -0700 From: "Joshua D. Drake" User-Agent: Thunderbird 1.5.0.10 (X11/20070403) MIME-Version: 1.0 To: flickchick_one CC: pgsql-admin@postgresql.org Subject: Re: preload libraries References: <614704.20770.qm@web52109.mail.re2.yahoo.com> In-Reply-To: <614704.20770.qm@web52109.mail.re2.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Tue, 22 May 2007 10:21:51 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/222 X-Sequence-Number: 25542 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 > 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/