plperl on AIX
I posted this in other lists with no response... Can anyone help?
I'm having trouble getting plperl to work on AIX 5.3.2.
Postgresql Version: 8.1.1
Perl Version: 5.8.7
I've rebuilt perl as a shared library version and built that into postgre
using --with-perl. The postgre build/install works fine, without errors.
The plperl regression tests all fail, though. Here are the test results
of the first regression test:
--
-- checkpoint so that if we have a crash in the tests, replay of the
-- just-completed CREATE DATABASE won't discard the core dump file
--
checkpoint;
--
-- Test result value processing
--
CREATE OR REPLACE FUNCTION perl_int(int) RETURNS INTEGER AS $$
return undef;
$$ LANGUAGE plperl;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
I've tried this same thing manually with the same result.
Does anyone have any suggestions on how to get this to work?
Thanks
John F Rizzo <jfrizzo@us.ibm.com> writes:
I'm having trouble getting plperl to work on AIX 5.3.2.
You need to gather more info. What shows up in the postmaster log
when the backend crashes? Also, get a debugger stack trace from
the core file the backend leaves behind. (If it doesn't leave a
core file then the first thing to do is fix that --- on Linux
"ulimit -c unlimited" before starting the postmaster helps, but
I'm not too familiar with AIX.)
regards, tom lane
In an attempt to throw the authorities off his trail, jfrizzo@us.ibm.com (John F Rizzo) transmitted:
I posted this in other lists with no response... �Can anyone help?
I'm having trouble getting plperl to work on AIX 5.3.2.
Postgresql Version: 8.1.1
Perl Version: 5.8.7
I've rebuilt perl as a shared library version and built that into postgre using --with-perl. �The postgre build/install works fine, without
errors.
The plperl regression tests all fail, though. �Here are the test results of the first regression test:
The first thing that comes to mind is the question of whether or not
Perl was compiled using the same compiler as was used for PostgreSQL.
If you're not sure, then perhaps using GCC for one and VAC for the
other might be what is turning out badly...
I know that mismatches of that sort have had adverse effects on AIX
and Solaris...
--
(reverse (concatenate 'string "moc.liamg" "@" "enworbbc"))
http://linuxdatabases.info/info/rdbms.html
"you can obvioulsy understand what i'm saying. you're just being
pendantic." -- bazzz777@yahoo.com