Обсуждение: problems with pltcl.so

"Josh Goldberg" <josh@4dmatrix.com> writes:
> ERROR:  Load of file /home/postgres/lib/pltcl.so failed: dlopen '/home/post=
> gres/lib/pltcl.so' failed. (Shared object "libtcl80.so.1" not found)

> I am on freebsd 4.4, I have libtcl80.so.1 in /usr/local/lib and not only is=
>  it in my ld-elf.so.hints file but I also manually put /usr/local/lib in my=
>  LD_LIBRARY_PATH to no avail.

I'm not very familiar with freebsd, but if it uses LD_LIBRARY_PATH, keep
in mind that the value that counts is the one in the postmaster's
environment.  Did you restart the postmaster with the corrected path in
its environment variables?

            regards, tom lane

my goodness that didn't even brush past my mind!  thanks much for the
assist! :)
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Josh Goldberg" <josh@4dmatrix.com>
Cc: "postgres-admin" <pgsql-admin@postgresql.org>
Sent: Tuesday, October 08, 2002 6:50 AM
Subject: Re: [ADMIN] problems with pltcl.so


> "Josh Goldberg" <josh@4dmatrix.com> writes:
> > ERROR:  Load of file /home/postgres/lib/pltcl.so failed: dlopen
'/home/post=
> > gres/lib/pltcl.so' failed. (Shared object "libtcl80.so.1" not found)
>
> > I am on freebsd 4.4, I have libtcl80.so.1 in /usr/local/lib and not only
is=
> >  it in my ld-elf.so.hints file but I also manually put /usr/local/lib in
my=
> >  LD_LIBRARY_PATH to no avail.
>
> I'm not very familiar with freebsd, but if it uses LD_LIBRARY_PATH, keep
> in mind that the value that counts is the one in the postmaster's
> environment.  Did you restart the postmaster with the corrected path in
> its environment variables?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

It was listed in the ldconfig hints file, but adding LD_LIBRARY_PATH to the
postmaster's login environment explicitly did the trick.
----- Original Message -----
From: "Chad R. Larson" <clarson@eldocomp.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>; "Josh Goldberg" <josh@4dmatrix.com>
Cc: "postgres-admin" <pgsql-admin@postgresql.org>
Sent: Tuesday, October 08, 2002 11:34 AM
Subject: Re: [ADMIN] problems with pltcl.so


> In FreeBSD there is a utility called "ldconfig(8)" that sets up the hint
> cache.  If you add something to a library directory you will need to
re-run
> it, or reboot (it is run out of /etc/rc).
>
> At 06:50 AM 10/8/02 , Tom Lane wrote:
> >"Josh Goldberg" <josh@4dmatrix.com> writes:
> > > ERROR:  Load of file /home/postgres/lib/pltcl.so failed: dlopen
> > '/home/post=
> > > gres/lib/pltcl.so' failed. (Shared object "libtcl80.so.1" not found)
> >
> > > I am on freebsd 4.4, I have libtcl80.so.1 in /usr/local/lib and not
> > only is=
> > >  it in my ld-elf.so.hints file but I also manually put /usr/local/lib
> > in my=
> > >  LD_LIBRARY_PATH to no avail.
> >
> >I'm not very familiar with freebsd, but if it uses LD_LIBRARY_PATH, keep
> >in mind that the value that counts is the one in the postmaster's
> >environment.  Did you restart the postmaster with the corrected path in
> >its environment variables?
> >
> >                         regards, tom lane
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 4: Don't 'kill -9' the postmaster
>
>          -crl
> --
> Chad R. Larson (CRL22)    chad@eldocomp.com
>    Eldorado Computing, Inc.   602-604-3100
>       5353 North 16th Street, Suite 400
>         Phoenix, Arizona   85016-3228
>