pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedproblems with pgaccess
3+ messages / 3 participants
[nested] [flat]
* problems with pgaccess
@ 1999-02-24 10:51 Francisco Alonso <alonsarp@fcu.um.es>
1999-02-24 15:20 ` Re: [INTERFACES] problems with pgaccess Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Francisco Alonso @ 1999-02-24 10:51 UTC (permalink / raw)
To: pgsql-interfaces
I am absolutely new with postgres. I have installed it (thanks to the
help of the mailing list) and it works properly. But now I want to
install pgaccess and I get an error message:
$ wish -f pgaccess.tcl template1
Error in startup script: couldn't load file "libpgtcl.so": libpq.so.1:
cannot open shared object file: No such file or directory
while executing
"load libpgtcl.so"
(procedure "main" line 6)
invoked from within
"main $argc $argv"
(file "pgaccess.tcl" line 5002)
I am using RedHat 5.2 on a Pentium 166.
I have read about problems loading libpgtcl library, but I don't know if
this is one of those problems.
I think this is one of those beginner's stupid problems, and probably it
has been discussed formerly in the mailing list, but I haven't find
anything about it. Could anybody kindly give me some idea?
Francisco Alonso Sarría
Area de Geografía Física
Universidad de Murcia
Campus de La Merced
E-30001 Murcia SPAIN
Tel: (968) 364357
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] problems with pgaccess
1999-02-24 10:51 problems with pgaccess Francisco Alonso <alonsarp@fcu.um.es>
@ 1999-02-24 15:20 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 1999-02-24 15:20 UTC (permalink / raw)
To: Francisco Alonso <alonsarp@fcu.um.es>; +Cc: pgsql-interfaces
Francisco Alonso <alonsarp@fcu.um.es> writes:
> $ wish -f pgaccess.tcl template1
> Error in startup script: couldn't load file "libpgtcl.so": libpq.so.1:
> cannot open shared object file: No such file or directory
Can you run "psql" successfully? If not, you probably forgot to set up
your environment so that the Postgres shared libraries can be found by
the dynamic loader. Under Linux I think you need to run ldconf to add
/usr/local/pgsql/lib (or wherever you put the libraries); not sure about
the details though.
If psql runs but you can't dynamically load libpgtcl, you are probably
running into the second-level-dependency problem: libpgtcl depends on
libpq, which in turn depends on libcrypt (if libcrypt is a separate
library on your system). A lot of dynamic loaders are too stupid to do
the right thing here. You have to help them out by marking libpgtcl as
depending directly on libcrypt. Try applying the following patch to
Makefile.in and rebuilding libpgtcl. (This patch will be in 6.5, and
I'm considering retrofitting it into 6.4.3 as well --- so let me know
if it helps.)
regards, tom lane
inline patch 1: pgsql/src/interfaces/libpgtcl/Makefile.in (+6/-1 lines) download inline-1.patch
*** REL6_4/pgsql/src/interfaces/libpgtcl/Makefile.in Sun Oct 18 20:00:41 1998
--- pgsql/src/interfaces/libpgtcl/Makefile.in Sun Feb 7 17:10:45 1999
***************
*** 27,33 ****
OBJS= pgtcl.o pgtclCmds.o pgtclId.o
! SHLIB_LINK= -L../libpq -lpq
# Shared library stuff, also default 'all' target
include $(SRCDIR)/Makefile.shlib
--- 27,38 ----
OBJS= pgtcl.o pgtclCmds.o pgtclId.o
! SHLIB_LINK+= -L../libpq -lpq
!
! # If crypt is a separate library, rather than part of libc, it may need
! # to be referenced separately to keep (broken) linkers happy. (This is
! # braindead; users of libpq should not need to know what it depends on.)
! SHLIB_LINK+= $(findstring -lcrypt,$(LIBS))
# Shared library stuff, also default 'all' target
include $(SRCDIR)/Makefile.shlib
* Re: [INTERFACES] problems with pgaccess
@ 1999-02-25 01:11 Shoku Yanagawa <yanagawa@cosmoele.co.jp>
0 siblings, 0 replies; 3+ messages in thread
From: Shoku Yanagawa @ 1999-02-25 01:11 UTC (permalink / raw)
To: pgsql-interfaces
> I am absolutely new with postgres. I have installed it (thanks to the
> help of the mailing list) and it works properly. But now I want to
> install pgaccess and I get an error message:
>
>
> $ wish -f pgaccess.tcl template1
> Error in startup script: couldn't load file "libpgtcl.so": libpq.so.1:
> cannot open shared object file: No such file or directory
> while executing
> "load libpgtcl.so"
> (procedure "main" line 6)
> invoked from within
> "main $argc $argv"
> (file "pgaccess.tcl" line 5002)
>
> I am using RedHat 5.2 on a Pentium 166.
>
I encountered same problem using RedHat 5.2 compatible.
go to libpgctl source directory
cd XXXX/postgres-6.4.2/src/intefaces/libpgtcl
make
make install
You can get libpgtcl.so in proper directory.
Cheers
---------------------------------
Name: Shoku Yanagawa ?i?o?i?1?a?j
Cosmo Electronics Corp.
Email: mailto:yanagawa@cosmoele.co.jp
Web Site: http://www.cosmoele.co.jp
Mirror Site: http://www.cosmoele.com
Video Phone : vphone.cosmoele.co.jp
Key fingerprint = 7A72 1BD2 C384 11B9 EA47 C040 D18D 7D83 225F 8AC2
Address:Postal Code 221
4-3-16 Rokkakubashi Kanagawa-ku Yokohama Japan
Tel:+81-(0)45-488-1301
Fax:+81-(0)45-488-1323
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-02-25 01:11 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-24 10:51 problems with pgaccess Francisco Alonso <alonsarp@fcu.um.es>
1999-02-24 15:20 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-02-25 01:11 Re: [INTERFACES] problems with pgaccess Shoku Yanagawa <yanagawa@cosmoele.co.jp>
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