Re: PostgreSQL TCL extension - Redhat 5

On 5/14/2013 5:02 PM, Oscar Calderon wrote:
> So i searched for an older version and i found this:
>
> http://yum.postgresql.org/8.4/redhat/rhel-5-x86_64/postgresql-tcl-1.6.2-1PGDG.rhel5.x86_64.rpm
>
> I had installed it without problems, and it appears when i execute
> SELECT * FROM pg_available_extensions; but when i try to install it,
> it gives me error because it looks for the .so file of tcl 8.5, and
> the server has tcl 8.4 . And because i'm not responsible of
> maintenance on the redhat server (that's another company task), they
> notified us that that's the maximum version of TCL that they can
> upgrade, so my doubt is if there's a version of postgresql tcl
> extension that works with tcl 8.4 or if there's another way to solve it.

that file is for postgresql 8.4, not 9.1

you want the postgresql91-pltcl package most likely.   I just checked
the one for RHEL5 with Postgres 9.2, and its linked to libtcl8.4.so

# rpm -ql postgresql92-pltcl
/usr/pgsql-9.2/bin/pltcl_delmod
/usr/pgsql-9.2/bin/pltcl_listmod
/usr/pgsql-9.2/bin/pltcl_loadmod
/usr/pgsql-9.2/lib/pltcl.so
......

# ldd /usr/pgsql-9.2/lib/pltcl.so
         linux-gate.so.1 =>  (0x40000000)
         libtcl8.4.so => /usr/lib/libtcl8.4.so (0x40018000)
         libdl.so.2 => /lib/libdl.so.2 (0x400d8000)
         libpthread.so.0 => /lib/libpthread.so.0 (0x400dd000)
         libm.so.6 => /lib/libm.so.6 (0x400f7000)
         libc.so.6 => /lib/libc.so.6 (0x40121000)
         /lib/ld-linux.so.2 (0x0035d000)




--
john r pierce                                      37N 122W
somewhere on the middle of the left coast