Bug#704802: plperl crashes immediately on kfreebsd

[Christoph Berg]

Re: Peter Eisentraut
> Creating a plperl function on kfreebsd (amd64) immediately crashes the
> PostgreSQL server in the plperl.so module.  You can see this either by
> running the built-in regression tests (should probably be done during
> the build anyway) or by running the tests from
> t/020_create_sql_remove.t in the postgresql-common package.
> 
> Everything else works, including all the other procedural languages
> (Python, Tcl).
> 
> I can also reproduce this problem with PostgreSQL Git master, so it's
> not specific to the packaging.  The actual problem might be somewhere
> down the stack (libperl etc.).

The failure mode has shifted since 2013. Now it looks like this:

postgres=# create extension plperl;
server closed the connection unexpectedly

... and the PostgreSQL server log then says:

/build/postgresql-13-u7Fppv/postgresql-13-13.1/build/../src/pl/plperl/Util.c: loadable library and perl binaries are mismatched (got handshake key 0xe500080, needed 0xe580080)

Christoph