Figured out the problem: the package in the official repository doesn't
really work. I had to use Red Hat packages.
Any reason for that?
Mladen Gogala wrote:
> I can't install plpython:
> bash-3.2$ createlang --echo plpythonu template1
> SELECT oid FROM pg_catalog.pg_language WHERE lanname = 'plpythonu';
> CREATE LANGUAGE "plpythonu";
> createlang: language installation failed: ERROR: could not access file
> "$libdir/plpython": No such file or directory
>
>
> Everything is installed from the official pgdg84 repository:
> -bash-3.2$ rpm -qa|grep postgres
> compat-postgresql-libs-4-1PGDG.rhel5
> postgresql-server-8.4.4-2PGDG.el5
> postgresql-plperl-8.4.4-2PGDG.el5
> postgresql-libs-8.4.4-2PGDG.el5
> postgresql-python-3.8.1-7PGDG.rhel5
> postgresql-jdbc-8.4.701-1PGDG.rhel5
> postgresql-8.4.4-2PGDG.el5
> postgresql-contrib-8.4.4-2PGDG.el5
>
> The database tells me the following:
>
> postgres=# select version();
>
> version
>
> --------------------------------------------------------------------------------
> ----------------------------------
> PostgreSQL 8.4.4 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC)
> 4.1.2 20
> 080704 (Red Hat 4.1.2-46), 64-bit
> (1 row)
> uname -a:
> Linux lpo-postgres-01 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010
> x86_64 x86_64 x86_64 GNU/Linux
>
> -bash-3.2$ cat /etc/redhat-release
> Red Hat Enterprise Linux Server release 5.5 (Tikanga)
> -bash-3.2$
>
>
--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com
The Leader in Integrated Media Intelligence Solutions