Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D52DC9FB259 for ; Tue, 22 May 2007 14:17:20 -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 13152-03 for ; Tue, 22 May 2007 14:17:08 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web52109.mail.re2.yahoo.com (web52109.mail.re2.yahoo.com [206.190.48.112]) by postgresql.org (Postfix) with SMTP id 344569FB2AC for ; Tue, 22 May 2007 14:17:09 -0300 (ADT) Received: (qmail 21105 invoked by uid 60001); 22 May 2007 17:15:51 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=vgg8EA7f4DUrdDbKSRTExwtwg2a21tNwCIkzC3zSrmLp+6ImRyFlk0jEMe0gfpjU2ZTldMKwZY88U5Q5q3iAW9BXuYWAeWpTul5iZYy1xU+Wf+WQh+ymAsmVeJ3UqDykkJz7Be4dYoE7DHoItdKh9qckUe8OqRvARUmAaQg4aYQ=; X-YMail-OSG: 9eQ88EoVM1mx0ZAxei5RHtb_v4ScIbrq_QNFitAucVGaiVPayYXnrBw9tLk1nc879g-- Received: from [207.160.168.243] by web52109.mail.re2.yahoo.com via HTTP; Tue, 22 May 2007 10:15:51 PDT Date: Tue, 22 May 2007 10:15:51 -0700 (PDT) From: flickchick_one Subject: preload libraries To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-952044047-1179854151=:20770" Content-Transfer-Encoding: 8bit Message-ID: <614704.20770.qm@web52109.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.131 tagged_above=0 required=5 tests=BAYES_00=-2.599, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447, HTML_30_40=0.374, HTML_MESSAGE=0.001 X-Spam-Level: * X-Archive-Number: 200705/221 X-Sequence-Number: 25541 --0-952044047-1179854151=:20770 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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: 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. --0-952044047-1179854151=:20770 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
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:
 
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. --0-952044047-1179854151=:20770--