Re: pgAccess fails to launch on HPUX

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers(at)postgreSQL(dot)org, pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: pgAccess fails to launch on HPUX
Date: 2001-02-07 19:50:04
Message-ID: 7937.981575404@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-interfaces

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Tom Lane writes:
>> Does anyone object if I modify pgaccess so that it always specifies the
>> full path to the library?

> If I had known that this was possible I would have done it myself already.
> ;-) This is a good idea in general because in a default installation
> pgaccess won't find libpgtcl on any system because it doesn't have the
> benefit of the -rpath/-R business.

Right, even with a cooperative Tcl+kernel, you need to set LD_LIBRARY_PATH
to make pgaccess work. Perhaps this will fix that. AFAICT, specifying
a full path in the Tcl 'load' command is legal on all systems. However,
we still have to rely on the dynamic linker to do the right thing with
the indirect dependency on libpq.so, so there may be systems that still
need LD_LIBRARY_PATH to find libpq.so.

> Please review/remove the note at the
> end of the pgaccess ref page if you fix this to your satisfaction.

Thanks for the pointer, I probably wouldn't have noticed that. But
given the above consideration, I'm not sure I want to remove the note
yet.

BTW, I'm also thinking about fixing pgaccess so that it honors the
--with-pgport configure setting and PGPORT environment variable, rather
than having the default port number 5432 hard-wired in.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Lamar Owen 2001-02-07 20:23:31 Re: Include files for SPI are not installed
Previous Message Adam Haberlach 2001-02-07 19:27:55 Sluggish inserts/updates ?

Browse pgsql-interfaces by date

  From Date Subject
Next Message Thies C. Arntzen 2001-02-07 19:56:12 Re: PostgreSQL and PHP persistent connections
Previous Message Peter Eisentraut 2001-02-07 19:20:16 Re: pgAccess fails to launch on HPUX