Thread: 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

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

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