Thread: 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/
Attachment
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/
Attachment
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/