From: flickchick_one <flickchick_one@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: preload libraries
Date: Tue, 22 May 2007 10:15:51 -0700 (PDT)
Message-ID: <614704.20770.qm@web52109.mail.re2.yahoo.com> (raw)
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.
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: flickchick_one@yahoo.com
Subject: Re: preload libraries
In-Reply-To: <614704.20770.qm@web52109.mail.re2.yahoo.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