Is discussed on pgsql-general: http://www.postgresql.org/message-id/CAFaPBrSvM_hsNVWRezucJMCCaJzAQg2f-TfzYh8VacihqrgFHQ@mail.gmail.com 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.
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";'
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";'
(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.
I have this fixed in my overlay. The ebuild appends the workaround.
Fixed, but only new installs will have the workaround appended.
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.
Running into this issue that Pascal ran into with 9.1 as well. No perl in this setup.