Re: Trouble loading Perl modules from postgresql.conf

Just an update for those interested. I found an insecure work around for
pre-loading any modules I may need by editing the "sitecustomize.pl" file,
essentially adding any use's and requires I need. As I said, probably not
secure since I hear there's been issues with sitecustomize.pl

From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Chris Greenhill
Sent: Wednesday, April 20, 2011 12:09 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Trouble loading Perl modules from postgresql.conf

Hello,

I'm having difficulty pre-loading Perl modules and my own libraries. When I
edit something like this into the postgresql.conf:

custom_variable_classes = 'plperl'

plperl.on_init = 'use MyModule;'

and restart the server it doesn't seem to load the modules (they don't
appear in %INC and my functions error out). Is there something else I need
to do? I'm using server 9.0.4 on a WinXP system with Perl 5.10.

Thanks for any help

-Chris