Thread: Installation problem (RH5, x86-64, Postgresql 8.4.4)
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
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
Mladen Gogala <mgogala@vmsinfo.com> writes:
> 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
I think you're missing the postgresql-plpython RPM. postgresql-python is
a client-side library, not the PL.
regards, tom lane
On Tue, 2010-08-10 at 17:34 -0400, Mladen Gogala wrote: > 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? What is wrong with the package that came from repository? I mean, what error did you get? -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachment
On 08/11/2010 11:51 AM, Devrim GÜNDÜZ wrote: > On Tue, 2010-08-10 at 17:34 -0400, Mladen Gogala wrote: > >> 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? >> > What is wrong with the package that came from repository? I mean, what > error did you get? > > createlang: language installation failed: ERROR: could not access file "$libdir/plpython": No such file or directory The file was in another package, not present in the repository. -- Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 www.vmsinfo.com The Leader in integrated Media Intelligence Solutions