PostgreSQL 15.3 / Plperl

Question

I've installed PostgreSQL 15.3 on a clean windows 10 laptop with the v3 language pack and I've set the correct paths and environment variables. I can install pltcl and plpython3u languages on the database but plperl will not install. Its reporting this in the logs

src/pl/plperl/Util.c: loadable library and perl binaries are mismatched (got first handshake key 0000000012700080, needed 0000000012600080)

Does anybody have any suggestions how to fix?

Thanks

Answer 1

The error has occurred because there is version mismatch between the PostgreSQL extension and installed Perl binaries. Check the version of Perl by running command perl -v If the version doesn't match then obtain the correct piperl extension that matches the installed Perl version.

Hope it resolves the issue.