Skip site navigation (1) Skip section navigation (2)

Re: preload libraries

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: flickchick_one <flickchick_one(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: preload libraries
Date: 2007-05-22 17:22:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
flickchick_one wrote:
> Hello all -
> I'm attempting to preload a shared object file ( 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 to use it. Just create the function 
that calls it :)

Joshua D. Drake

> preload_libraries = '/etc/postgresql/8.1/main/'
> 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, 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

Donate to the PostgreSQL Project:
PostgreSQL Replication:

In response to

pgsql-admin by date

Next:From: Chris HooverDate: 2007-05-22 17:25:01
Subject: What happens on a commit?
Previous:From: flickchick_oneDate: 2007-05-22 17:15:51
Subject: preload libraries

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group