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/
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
