Bug 518522 – dev-db/postgresql-server with dev-lang/perl-5.18.2-r1 - broken plperl functions

• Status: RESOLVED FIXED
• Product: Gentoo Linux

[Description Chris Mayo 2014-07-29 18:54:31 UTC]

Is discussed on pgsql-general:
http://www.postgresql.org/message-id/[e-mail]

Simple test query from the above link:
do $$ "\N{U+263A}" =~ /[[:punct:]]/$$ language plperl;

Results in:
ERROR:  Unable to load utf8.pm into plperl at line 1.
BEGIN failed--compilation aborted.

A workaround is to change the function language from plperl to the untrusted plperlu.

[Comment 1 Andreas K. Hüttel 2014-09-10 19:36:44 UTC]

http://dba.stackexchange.com/questions/65268/how-can-i-load-utf8-into-plperl-by-default

The quoted URL has a workaround, could you please check if that helps?

plperl.on_init = 'use utf8; use re; package utf8; require "utf8_heavy.pl";'

[Comment 2 Chris Mayo 2014-09-11 16:25:09 UTC]

Seems to be working OK after adding to /etc/postgresql-9.3/postgresql.conf:
plperl.on_init = 'use utf8; use re; package utf8; require "utf8_heavy.pl";'

[Comment 3 Andreas K. Hüttel 2014-09-12 21:19:14 UTC]

(In reply to Chris Mayo from comment #2)
> Seems to be working OK after adding to /etc/postgresql-9.3/postgresql.conf:
> plperl.on_init = 'use utf8; use re; package utf8; require "utf8_heavy.pl";'

OK. Keeping this bug open, but it isnt blocking Perl 5.18 anymore.

[Comment 4 Aaron W. Swenson 2014-12-04 11:33:13 UTC]

I have this fixed in my overlay. The ebuild appends the workaround.

[Comment 5 Aaron W. Swenson 2014-12-28 18:12:24 UTC]

Fixed, but only new installs will have the workaround appended.

[Comment 6 Pascal Jufer 2015-02-12 18:05:14 UTC]

This additional parameter should only be applied if PostgreSQL is installed with the perl USE flag. Otherwise the parameter isn't recognized and starting the server will fail with the following error:

 * Caching service dependencies ...                                                                     
 * /run/postgresql: creating directory
 * /run/postgresql: correcting owner
 * Starting PostgreSQL ...
FATAL:  unrecognized configuration parameter "plperl.on_init"
 * start-stop-daemon: failed to start `/usr/lib64/postgresql-9.1/bin/postgres'
 * Check the log for a possible explanation of the above error. The log may be
 *     /var/lib/postgresql/9.1/data/postmaster.log
 * Or wherever you configured PostgreSQL 9.1 log messages to be sent.                                   
 * ERROR: postgresql-9.1 failed to start
 These settings are initialized by initdb, but they can be changed.

[Comment 7 devsk 2015-02-16 05:03:15 UTC]

Running into this issue that Pascal ran into with 9.1 as well. No perl in this setup.