Thread: Create language plperlu Error
Sir/Madam,
Plateform: RHEL6.5, Postgresql9.4.0.
create extension plperl;
Create language plperl;
I have done following settings:
Perl version 5.10
vi /etc/ld.so.conf.d/libperl.conf
/usr/lib/5.10/multi-thread/i386.../CORE/libperl.so
ldconfig
ERROR: Can not load "/opt/Postgresql/9.4/lib/postgresql/plperl.so" undefined symbol Perl_sv_2bool_flags
ERROR: could not load library "/opt/PostgreSQL/9.4/lib/postgresql/plperl.so":
/opt/PostgreSQL/9.2/lib/postgresql/plperl.so: undefined symbol: Perl_sv_2bool_flags
How do I solve.
Kindly resolve it.
Regards
Om Prakash
On 8/1/2016 10:47 PM, Om Prakash Jaiswal wrote: > Sir/Madam, > Plateform: RHEL6.5, Postgresql9.4.0. > > create extension plperl; > Create language plperl; > > I have done following settings: > Perl version 5.10 > vi /etc/ld.so.conf.d/libperl.conf > /usr/lib/5.10/multi-thread/i386.../CORE/libperl.so > ldconfig > > ERROR: Can not load "/opt/Postgresql/9.4/lib/postgresql/plperl.so" > undefined symbol Perl_sv_2bool_flags > > |ERROR:could notload library > "/opt/PostgreSQL/9.4/lib/postgresql/plperl.so":/opt/PostgreSQL/9.2/lib/postgresql/plperl.so:undefinedsymbol:Perl_sv_2bool_flags > How do I solve. Kindly resolve it. | /opt suggests you're running the EnterpriseDB installation of Postgresql. I would instead use the RPM distribution from http://yum.postgresql.org, this integrates just fine with plperl, plpython, etc on redhat and centos and other similar platforms. btw, RHEL 6.5 is several years behind in security updates, I believe 6.8 is the current update, you really should update. ditto, PostgreSQL 9.4.0 is long superseded, current 9.4 version is 9.4.8 -- john r pierce, recycling bits in santa cruz
Hi Prakash, In addition to John's update, What plperl.so is telling you that one of its symbols is undefined. This may be due to compile options or may means you need a newer version of Perl and libperl.so (5.10.1 is quite old). Recent versions of PotgreSQL and plperl usually require a newer version of perl than the one you cite. So try using perl 5.14 and greater which contains Perl_sv_2bool_flags. On 2 August 2016 at 11:35, John R Pierce <pierce@hogranch.com> wrote: > On 8/1/2016 10:47 PM, Om Prakash Jaiswal wrote: > > Sir/Madam, > Plateform: RHEL6.5, Postgresql9.4.0. > > create extension plperl; > Create language plperl; > > I have done following settings: > Perl version 5.10 > vi /etc/ld.so.conf.d/libperl.conf > /usr/lib/5.10/multi-thread/i386.../CORE/libperl.so > ldconfig > > ERROR: Can not load "/opt/Postgresql/9.4/lib/postgresql/plperl.so" > undefined symbol Perl_sv_2bool_flags > > ERROR: could not load library "/opt/PostgreSQL/9.4/lib/postgresql/plperl.so": /opt/PostgreSQL/9.2/lib/postgresql/plperl.so:undefined symbol: Perl_sv_2bool_flags > > How do I solve. > Kindly resolve it. > > > /opt suggests you're running the EnterpriseDB installation of Postgresql. > I would instead use the RPM distribution from http://yum.postgresql.org, > this integrates just fine with plperl, plpython, etc on redhat and centos > and other similar platforms. > > btw, RHEL 6.5 is several years behind in security updates, I believe 6.8 > is the current update, you really should update. > > ditto, PostgreSQL 9.4.0 is long superseded, current 9.4 version is 9.4.8 > > > -- > john r pierce, recycling bits in santa cruz > > -- --Regards Ranjeet R. Dhumal
On 8/1/2016 11:45 PM, Ranjeet Dhumal wrote: > > What plperl.so is telling you that one of its symbols is undefined. > This may be due to compile options or may means you need a newer > version of Perl and libperl.so (5.10.1 is quite old). Recent versions > of PotgreSQL and plperl usually require a newer version of perl than > the one you cite. > > So try using perl 5.14 and greater which contains Perl_sv_2bool_flags. RHEL 6 has perl 5.10.1, you don't update it. you could install a newer perl in a different location but its pretty unlikely the postgres stuff would use it as-is. the PGDG rpm distributions are built to use the appropriate system perl. I don't know what enterprisedb is building their /opt/postgres to use. -- john r pierce, recycling bits in santa cruz
> Sir/Madam, > Plateform: RHEL6.5, Postgresql9.4.0. > > > create extension plperl; > > Create language plperl; > > > I have done following settings: > > Perl version 5.10 > vi /etc/ld.so.conf.d/libperl.conf > /usr/lib/5.10/multi-thread/i386.../CORE/libperl.so > ldconfig > > > ERROR: Can not load "/opt/Postgresql/9.4/lib/postgresql/plperl.so" > undefined symbol Perl_sv_2bool_flags > > > ERROR: could not load library "/opt/PostgreSQL/9.4/lib/postgresql/plperl.so": > /opt/PostgreSQL/9.2/lib/postgresql/plperl.so: undefined symbol: Perl_sv_2bool_flags > > How do I solve. > Kindly resolve it. > > Regards > Om Prakash Do you have the packet postgresql-plperl installed? / Eskil
Yes, I have installed postgresql-plperl package.
But I am not able to execute:
create extension plperl
create language plperlu
On Monday, 8 August 2016 12:56 PM, Johan Fredriksson <eskil@kth.se> wrote:
> Sir/Madam,
> Plateform: RHEL6.5, Postgresql9.4.0.
>
>
> create extension plperl;
>
> Create language plperl;
>
>
> I have done following settings:
>
> Perl version 5.10
> vi /etc/ld.so.conf.d/libperl.conf
> /usr/lib/5.10/multi-thread/i386.../CORE/libperl.so
> ldconfig
>
>
> ERROR: Can not load "/opt/Postgresql/9.4/lib/postgresql/plperl.so"
> undefined symbol Perl_sv_2bool_flags
>
>
> ERROR: could not load library "/opt/PostgreSQL/9.4/lib/postgresql/plperl.so":
> /opt/PostgreSQL/9.2/lib/postgresql/plperl.so: undefined symbol: Perl_sv_2bool_flags
>
> How do I solve.
> Kindly resolve it.
>
> Regards
> Om Prakash
Do you have the packet postgresql-plperl installed?
/ Eskil
----- Mensaje original ----- > De: "Om Prakash Jaiswal" <op12om@yahoo.co.in> > Para: pgsql-performance@postgresql.org, "Pgsql-admin" <pgsql-admin@postgresql.org>, pgsql-bugs@postgresql.org > Enviados: Martes, 2 de Agosto 2016 2:47:19 > Asunto: [PERFORM] Create language plperlu Error > > > > Sir/Madam, > Plateform: RHEL6.5, Postgresql9.4.0. > > > create extension plperl; > > Create language plperl; > > > I have done following settings: > > Perl version 5.10 > vi /etc/ld.so.conf.d/libperl.conf > /usr/lib/5.10/multi-thread/i386.../CORE/libperl.so > ldconfig > > > ERROR: Can not load "/opt/Postgresql/9.4/lib/postgresql/plperl.so" > undefined symbol Perl_sv_2bool_flags > > ERROR : could not load library > "/opt/PostgreSQL/9.4/lib/postgresql/plperl.so" : /opt/ PostgreSQL / > 9.2 / lib / postgresql / plperl . so : undefined symbol : > Perl_sv_2bool_flags > > How do I solve. > Kindly resolve it. > I think your 9.4 is using the 9.2 version of the plperl.so library. Maybe you should recompile. HTH Gerardo