Re: pgacess: cant find libpgctl (no faq !)

From: Brett Schwarz <brett_schwarz(at)yahoo(dot)com>
To: pilsl(at)goldfisch(dot)at
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pgacess: cant find libpgctl (no faq !)
Date: 2002-10-22 14:49:33
Message-ID: 1035298174.6559.49.camel@thor
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2002-10-22 at 06:51, pilsl(at)goldfisch(dot)at wrote:
> I compiled postgres 7.2.3 (--with-tcl) and newest pgacess (0.98.8.b2).
>
> While I got the libpgctl-libraries in the expected place and exported the
> PGLIB-variable I still get the error:
>
> Error: can not find libpgtcl.so shared library.
>
> # ls -l $PGLIB/libpgt*
> -rw-r--r-- 1 root root 31554 Oct 22 15:01 /opt/local/pgsql/lib/libpgtcl.a
> lrwxrwxrwx 1 root root 15 Oct 22 15:01 /opt/local/pgsql/lib/libpgtcl.so -> libpgtcl.so.2.2
> lrwxrwxrwx 1 root root 15 Oct 22 15:01 /opt/local/pgsql/lib/libpgtcl.so.2 -> libpgtcl.so.2.2
> -rwxr-xr-x 1 root root 36151 Oct 22 15:01 /opt/local/pgsql/lib/libpgtcl.so.2.2
> # ls -l $PGLIB/libpq*
> -rw-r--r-- 1 root root 87764 Oct 22 15:01 /opt/local/pgsql/lib/libpq.a
> lrwxrwxrwx 1 root root 12 Oct 22 15:01 /opt/local/pgsql/lib/libpq.so -> libpq.so.2.2
> lrwxrwxrwx 1 root root 12 Oct 22 15:01 /opt/local/pgsql/lib/libpq.so.2 -> libpq.so.2.2
> -rwxr-xr-x 1 root root 70037 Oct 17 2001 /opt/local/pgsql/lib/libpq.so.2.1
> -rwxr-xr-x 1 root root 79911 Oct 22 15:01 /opt/local/pgsql/lib/libpq.so.2.2
>
>
> I also added the pglib-path to my ld.so.conf and I also copied the
> above libraries to my "normal" lib-path (/usr/local/lib)
>

I assume you ran ldconfig after changing ld.so.conf (although I don't
think this is the problem).

> I also played around with trailing slashes and that stuff.
>
>
> My tcl-version is a recent one (8.3) and I couldnt find any older
> non-beta-pgaccess versions. Somewhere they say only 7.2.1 and 7.2.2
> is supported but I'm sure they just didnt know about 7.2.3 when
> writing it on the wiki-web at www.pgaccess.org ;)
>
It should work with 7.2.3. Part of the problem is that the error message
you got is too generic. It is printed if PGA can not load the shared lib
(which it assumes is because it can't be found).

Do you happen to have multiple versions of Tcl installed on your
computer? If I remember correctly, libpgtcl is not built with stubs
enabled, so you need to make sure you get the correct Tcl version. Other
then that, I am not sure what is going on.

Also, what are the permissions on the lib directory?

If you want, you can add some debugging statements, and send me the
output:

in pgaccess.tcl search for the line
if {[catch {load ${libpgtclpath}[info sharedlibextension]}]} {

change this to:
if {[catch {load ${libpgtclpath}[info sharedlibextension]} err]} {

and then add a line right after it:
puts "ERROR MSG: $err"

Then send me the output after running pgaccess...

--brett

p.s. Which Linux distro?

--
Brett Schwarz
brett_schwarz AT yahoo.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2002-10-22 15:12:28 Re: replication
Previous Message Tom Lane 2002-10-22 14:49:08 Re: looking for documentation about the optimizer