From: Ed Loehr <eloehr@austin.rr.com>
To: Don Oliver <dayo_nanaimo@hotmail.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Pgaccess - missing file, can't start
Date: Fri, 25 Feb 2000 22:48:26 -0600
Message-ID: <38B75B1A.48980BC4@austin.rr.com> (raw)
References: <20000226031947.29077.qmail@hotmail.com>
Don Oliver wrote:
>
> I installed Pgaccess as per the instructions in the README.
> The tutorial states that a file named pgaccess.tcl starts the program.
> There is no file named pgaccess.tcl anywhere on the system.
> There is, however, a file named pgaccess (no extension) in
> /usr/local/pgaccess.
>
> The README which was put in the pgaccess directory,
> states that it should be run with pgaccess, rather than pgaccess.tcl.
> Also, as per this file, I checked that the variables PGACCESS_HOME,
> PATH_TO_WISH are set to the appropriate directories.
I think pgaccess is what you want. A case of confused documentation,
I think.
> Tcl/Tk 8.0 are installed and tested.
> The postmaster is running, PostgreSQL 6.5.3
> I started pgaccess from /usr/local/pgaccess (I tried it with, and without,
> the optional [database].
>
> Here is the resulting error message:
>
> Error in startup script: couldn't load file "libpgtcl.so": libpgtcl.so:
> cannot open shared object file: No such file or directory
> while executing
> "load libpgtcl[info sharedlibextension]"
> (procedure "main" line 3)
> invoked from within
> "main $argc $argv"
> (file "usr/local/pgaccess/main.tcl" line 249)
All this is from vague recollection of running into the same issues
months ago, so caveat emptor...
It could be the file does not exist, or it could be the system cannot
find it. If it doesn't exist, I vaguely recall you may need to build
postgresql with tcl and tk enabled in order to get the library, eg.,
configure --with-tcl --with-tk # and whatever other flags you need
If /usr/local/pgsql is your postgres install root, then you should
end-up with a /usr/local/pgsql/lib/libpgtcl.so file.
If it exists, inability to find a shared object file has to do with
your library load path as defined by /etc/ld.so.conf. Here's mine:
% cat /etc/ld.so.conf
/usr/i486-linux-libc5/lib
/usr/lib
/usr/lib/qt-1.44/lib
/usr/lib/qt-2.0.1/lib
/usr/local/pgsql/lib
/usr/X11R6/lib
This is the sequence of locations the system will look to find shared
object files. I manually added /usr/local/pgsql/lib to this file.
Alternatively, you could add the path to your LD_LIBRARY_PATH
environment variable.
Hope that helps.
Cheers,
Ed Loehr
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: eloehr@austin.rr.com, dayo_nanaimo@hotmail.com
Subject: Re: [INTERFACES] Pgaccess - missing file, can't start
In-Reply-To: <38B75B1A.48980BC4@austin.rr.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox