Обсуждение: how does one set the plpython python interpreter?

Hello,
Hopefully this hasn't been answered already.  I attempted to do full
due-diligence on it, and could find no answer anywhere.

Basically my problem is that my server has both python 2.3 and python
2.4 installed (strange but unavoidable reasons behind this), and it
appears that my installation of postgres is using the 2.3 version for
my plpython scripts - and I need it to use the python 2.4 version.

The 2.4 version is first in all the paths including user postgres on
my server, but it seems to keep using python 2.3.

Where can I configure which version (or path) that postgres will use?
I assume that a python interpreter is not included inside the
postgresql-python addon, and that it just uses an already-installed
python interpreter.

As a corollary, if I can configure the path to the python interpreter
then I should be able to install my own python libraries for plpython
to use (and since it's "untrusted" anyways...), correct?

Many thanks if anyone can shed some light on this.
-Roger

roger wrote:
> Where can I configure which version (or path) that postgres will use?

It uses whatever "python" program it can find first in the path.  If 
your observation is different, please show the relevant output from 
configure or config.log.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

On May 5, 1:34 am, pete...@gmx.net (Peter Eisentraut) wrote:
> roger wrote:
> > Where can I configure which version (or path) that postgres will use?
>
> It uses whatever "python" program it can find first in the path.  If
> your observation is different, please show the relevant output from
> configure or config.log.
>
> --
> Peter Eisentrauthttp://developer.postgresql.org/~petere/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

Hi Peter,
After doing a little more digging, it appears as if the python version
used is hardcoded into the plpython.so  (I'm not sure if plpython.so
is actually doing the python interpretation itself or not)

this is an ldd output on my plpython.so:

# ldd plpython.so       libpython2.3.so.1.0 => /usr/lib/libpython2.3.so.1.0
(0x00c37000)       libpthread.so.0 => /lib/tls/libpthread.so.0 (0x00edd000)       libdl.so.2 => /lib/libdl.so.2
(0x00981000)      libutil.so.1 => /lib/libutil.so.1 (0x00111000)       libm.so.6 => /lib/tls/libm.so.6 (0x00693000)
 libc.so.6 => /lib/tls/libc.so.6 (0x006bd000)       /lib/ld-linux.so.2 (0x0091c000)
 

I installed postgres from RHES 4 RPM.  So not sure if that
libpython2.3 dependency was done by the RPM builder or was done when I
did the install.  My pg_config seems to indicate the install
configuration used the directories (/usr/lib and /usr/bin) where my
Python 2.3 is (Python 2.4 is in /usr/local/bin)

So I'm now wondering how I can get the plpython.so to depend on
python2.4.  Do I have to reinstall, or is there some way of just
redoing the plpython.so?

The really weird part is that I wrote a plpython script to write out
python environment vars:

CREATE OR REPLACE FUNCTION blah(varchar) RETURNS integer AS $$   import sys   plpy.notice("python exec = '%s'" %
sys.executable)  plpy.notice("python version = '%s'" % sys.version)   plpy.notice("python path = '%s'" % sys.path)
return1
 
$$ LANGUAGE plpythonu;

And I get the following output:
NOTICE:  ("python exec = '/usr/local/bin/python'",)
NOTICE:  ("python version = '2.3.4 (#1, Oct 11 2006, 06:18:43) \n[GCC
3.4.6 20060404 (Red Hat 3.4.6-3)]'",)
NOTICE:  ("python path = '['/usr/lib/python23.zip', '/usr/lib/
python2.3', '/usr/lib/python2.3/plat-linux2', '/usr/lib/python2.3/lib-
tk', '/usr/lib/python2.3/lib-dynload', '/usr/lib/python2.3/site-
packages', '/usr/lib/python2.3/site-packages/gtk-2.0']'",)

The weird part being the first line:  plpython thinks it's being run
from /usr/local/bin/python (which is 2.4), when the second line
clearly indicates version 2.3
Strange...

Anyways, for completeness, my pg_config gives:

# pg_config
BINDIR = /usr/bin
DOCDIR = /usr/share/doc/pgsql
INCLUDEDIR = /usr/include
PKGINCLUDEDIR = /usr/include/pgsql
INCLUDEDIR-SERVER = /usr/include/pgsql/server
LIBDIR = /usr/lib
PKGLIBDIR = /usr/lib/pgsql
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/man
SHAREDIR = /usr/share/pgsql
SYSCONFDIR = /etc/sysconfig/pgsql
PGXS = /usr/lib/pgsql/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--build=i686-redhat-linux-gnu' '--host=i686-redhat-linux-
gnu' '--target=i686-redhat-linux-gnu' '--program-prefix=' '--prefix=/
usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--
sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--
libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--
sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/
share/info' '--disable-rpath' '--with-perl' '--with-tcl' '--with-
tclconfig=/usr/lib' '--with-python' '--with-openssl' '--with-pam' '--
with-krb5' '--with-includes=/usr/include' '--with-libraries=/usr/lib'
'--enable-nls' '--sysconfdir=/etc/sysconfig/pgsql' '--datadir=//usr/
share/pgsql' '--with-docdir=/usr/share/doc' 'CFLAGS=-O2 -g -pipe -m32 -
march=i686 -mtune=pentium4 -I/usr/include/et' 'CPPFLAGS= -I/usr/
include/et' 'build_alias=i686-redhat-linux-gnu' 'host_alias=i686-
redhat-linux-gnu' 'target_alias=i686-redhat-linux-gnu'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE -I/usr/include
CFLAGS = -O2 -g -pipe -m32 -march=i686 -mtune=pentium4 -I/usr/include/
et -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-
after-statement -Wendif-labels -fno-strict-aliasing
CFLAGS_SL = -fpic
LDFLAGS = -L/usr/lib
LDFLAGS_SL =
LIBS = -lpgport -lpam -lssl -lcrypto -lkrb5 -lz -lreadline -ltermcap -
lcrypt -lresolv -lnsl -ldl -lm -lbsd
VERSION = PostgreSQL 8.1.5

So, any ideas on how I can get plpython.so to use Python 2.4?
Any help is greatly appreciated.
thanks,
-Roger

roger wrote:
> So, any ideas on how I can get plpython.so to use Python 2.4?

You'll have to rebuild the whole thing.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/