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:
ERRR: plpython:
function "update_donor_yearly" failed
DETAIL: exceptions.SystemExit:
ERRR: 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
(end of broadcast)
TIP 5: don't forget to increase your free space map settings

"Clodoaldo Pinto Neto" <clodoaldo.pinto (AT) gmail (DOT) comwrites:
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 " 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

(end of broadcast)
TIP 6: explain analyze is your friend

2006/10/27, Tom Lane <tgl (AT) sss (DOT) pgh.pa.us>:
"Clodoaldo Pinto Neto" <clodoaldo.pinto (AT) gmail (DOT) comwrites:
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 " points to).

My mistake, I was looking at /usr/lib/pgsql

# pg_config
/usr/lib/pgsql

# ll /usr/lib/pgsql/pl*
-rwxr-xr-x 1 root root 166887 26 22:12 /usr/lib/pgsql/plperl.so
-rwxr-xr-x 1 root root 340887 26 22:12 /usr/lib/pgsql/plpgsql.so
-rwxr-xr-x 1 root root 76833 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

(end of broadcast)
TIP 5: don't forget to increase your free space map settings

2006/10/27, Devrim GUNDUZ <devrim (AT) commandprompt (DOT) com>:
Hi,

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

(end of broadcast)
TIP 4: Have you searched our list archives?

2006/10/27, Devrim GUNDUZ <devrim (AT) commandprompt (DOT) 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

(end of broadcast)
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly