DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=iUArcQq+kp0FpFk5iFn1Y8SMT/4Z+n8paUrGuyldnasSepo8Cc/dOupqbeIbpmHuND7pq6U4JjOizXo0QLmOkcrSwanQRZrK7192s9m1uiCj2eLJg1kICKExBOSWfDXElRH76/wKROMiu+XyYEWkaOya2dADKg0KLIWlIE37GdY=
Message-ID: <4f4c2a010708150616se51de62u3c59d7722c3d5097@mail.gmail.com>
Date: Wed, 15 Aug 2007 09:16:23 -0400
From: "Jon Horsman" <horshaq@gmail.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Subject: Re: When is a shared library unloaded?
Cc: "sql pgsql" <pgsql-sql@postgresql.org>
In-Reply-To: <10738.1187120065@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <4f4c2a010708141142p70c199ednab3ceffb4ce9f138@mail.gmail.com>
	<10738.1187120065@sss.pgh.pa.us>

> "Jon Horsman" <horshaq@gmail.com> writes:
> > I'm randomly having issues with my triggers not firing (it turns out
> > they are getting removed) and when i turned INFO logs on i saw the
> > following
>
> > 2007-08-14 13:41:44.740305500 LOCATION:  _fini, medbevent_init.c:129
> > 2007-08-14 13:41:45.790850500 INFO:  00000: medbeventlib -Unloading
> > library _fini() is called
>
> > Could someone please explain when a shared library gets
> > loaded/unloaded and how this all works?
>
> Are you sure the above doesn't just occur during server process
> termination?  AFAIK Postgres never unloads a library, except when you
> specifically command it to load an updated version via the LOAD command.
>
>                         regards, tom lane

Yup, the server process is still up and going, i have other clients
connected to postgres that still function when this happens.  I'm not
using the LOAD command anywhere so thats not the problem.  One of my
colleagues was doing some reading and said he found something that
stating that the fini() function is "unreliable", i'm not sure where
he read that though...

Jon.