plpython.so
I had 8.1.4 i386 installed from the FC5 repository.
To upgrade to 8.1.5 I downloaded the srpm from pgsql mirrors and
rebuilt it for i686. Then installed the 8 resulting rpms with yum
update from a local repo.
When I ran the application I had this error:
psql:/fahstats/scripts/sql/fahstats.sql:197: ERROR: plpython:
function "update_donor_yearly" failed
DETAIL: exceptions.SystemExit:
psql:/fahstats/scripts/sql/fahstats.sql:140: ERROR: could not access
file "$libdir/plpython": No such file or directory
I noticed there was no /usr/lib/plpython.so. Then with more attention
i also noticed there was no postgresql-python in the 8 rpms built from
the srpm in the pgsql mirror.
Then I downloaded the postgresql-python rpm from the mirror to the
local repo and tried yum update but it failed with no messages. I did
yum remove postgresql-python and yum install postgresql-python which
worked and installed the new version.
But I'm still with no /usr/lib/plpython.so. What am i missing?
Regards, Clodoaldo Pinto Neto
"Clodoaldo Pinto Neto" <clodoaldo.pinto@gmail.com> writes:
But I'm still with no /usr/lib/plpython.so. What am i missing?
That's not where we keep it. Try /usr/lib/pgsql/plpython.so
(or wherever "pg_config --pkglibdir" points to).
Also, the .so is probably in the postgresql-pl RPM not postgresql-python,
unless Devrim has moved things around when I wasn't looking.
If the .so is there and you're still getting load failures, try
"ldd" on the .so to see if it's missing some dependent library.
regards, tom lane
2006/10/27, Tom Lane <tgl@sss.pgh.pa.us>:
"Clodoaldo Pinto Neto" <clodoaldo.pinto@gmail.com> writes:
But I'm still with no /usr/lib/plpython.so. What am i missing?
That's not where we keep it. Try /usr/lib/pgsql/plpython.so
(or wherever "pg_config --pkglibdir" points to).
My mistake, I was looking at /usr/lib/pgsql
# pg_config --pkglibdir
/usr/lib/pgsql
# ll /usr/lib/pgsql/pl*
-rwxr-xr-x 1 root root 166887 Oct 26 22:12 /usr/lib/pgsql/plperl.so
-rwxr-xr-x 1 root root 340887 Oct 26 22:12 /usr/lib/pgsql/plpgsql.so
-rwxr-xr-x 1 root root 76833 Oct 26 22:12 /usr/lib/pgsql/pltcl.so
Also, the .so is probably in the postgresql-pl RPM not postgresql-python,
I have postgresql-pl installed:
# yum list installed postgresql\*
Loading "installonlyn" plugin
Installed Packages
postgresql.i686 8.1.5-3PGDG installed
postgresql-contrib.i686 8.1.5-3PGDG installed
postgresql-debuginfo.i386 8.1.4-1.FC5.1 installed
postgresql-devel.i686 8.1.5-3PGDG installed
postgresql-docs.i686 8.1.5-3PGDG installed
postgresql-jdbc.i686 8.1.407-4PGDG installed
postgresql-libs.i686 8.1.5-3PGDG installed
postgresql-odbc.i686 08.02.0100-2PGDG installed
postgresql-odbc-debuginfo.i386 08.01.0200-1.2 installed
postgresql-pl.i686 8.1.5-3PGDG installed
postgresql-python.i686 3.8.1-3PGDG installed
postgresql-server.i686 8.1.5-3PGDG installed
postgresql-tcl.i386 8.1.4-1.FC5.1 installed
postgresql-test.i686 8.1.5-3PGDG installed
Clodoaldo
Hi,
On Fri, 2006-10-27 at 11:46 -0400, Tom Lane wrote:
Also, the .so is probably in the postgresql-pl RPM not
postgresql-python, unless Devrim has moved things around when I wasn't
looking.
Yeah, it is my mistake :-( I had removed plpython.so from installed
files :( Sorry Cladoaldo and others.
I need to make another respin tonite. This release cycle was really
nightmare for me.
Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
2006/10/27, Devrim GUNDUZ <devrim@commandprompt.com>:
Hi,
On Fri, 2006-10-27 at 11:46 -0400, Tom Lane wrote:
Also, the .so is probably in the postgresql-pl RPM not
postgresql-python, unless Devrim has moved things around when I wasn't
looking.Yeah, it is my mistake :-( I had removed plpython.so from installed
files
Is it a problem if i use plpython.so from 8.1.4?
Clodoaldo
Hi,
On Fri, 2006-10-27 at 13:55 -0300, Clodoaldo Pinto Neto wrote:
Is it a problem if i use plpython.so from 8.1.4?
I don't know. We need to check commit logs for plpython.
Anyway... I have uploaded new sets. SRPMs and FC5 RPMs will be in main
FTP site in an hour. They are labeled as 8.1.5-4PGDG .
Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
2006/10/27, Devrim GUNDUZ <devrim@commandprompt.com>:
Hi,
Anyway... I have uploaded new sets. SRPMs and FC5 RPMs will be in main
FTP site in an hour. They are labeled as 8.1.5-4PGDG .
Thanks! Clodoaldo
Hi,
On Fri, 2006-10-27 at 22:37 +0300, Devrim GUNDUZ wrote:
Anyway... I have uploaded new sets. SRPMs and FC5 RPMs will be in main
FTP site in an hour. They are labeled as 8.1.5-4PGDG
It is really a nightmare... David Fetter has just found a problem that
breaks 64 bit builds. I have updated SRPMs on FTP sites. They are marked
as 8.1.5-5PGDG. FC5 RPMs will be there in an hour.
This weekend I'll be setting up a new buildfarm for RPMs using FC6+Xen.
With that, I will be able to test packages much more,before releasing
them.
Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/