Обсуждение: 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/