Обсуждение: psql symbol lookup error

Поиск
Список
Период
Сортировка

psql symbol lookup error

От
Rich Shepard
Дата:
   I have -9.0.1 installed in /usr/local/pgsql and my accounting software
(Ledger123) can access its data there. However, when I try to run 'psql
aesi' (the L123 database), which is owned by me, on the command line I see:

[rshepard@salmo ~]$ psql aesi
psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams

   I've not encountered this with previous versions of postgres installed in
/var/lib/pgsql/. I would like to understand why I get this error trying to
run on the command line while L123 apparently has no problems using the
httpd/firefox front ends.

TIA,

Rich

Re: psql symbol lookup error

От
Merlin Moncure
Дата:
On Tue, Dec 14, 2010 at 1:24 PM, Rich Shepard <rshepard@appl-ecosys.com> wrote:
>  I have -9.0.1 installed in /usr/local/pgsql and my accounting software
> (Ledger123) can access its data there. However, when I try to run 'psql
> aesi' (the L123 database), which is owned by me, on the command line I see:
>
> [rshepard@salmo ~]$ psql aesi
> psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
>
>  I've not encountered this with previous versions of postgres installed in
> /var/lib/pgsql/. I would like to understand why I get this error trying to
> run on the command line while L123 apparently has no problems using the
> httpd/firefox front ends.

you have an older version of libpq in your library path, probably in
/usr/lib.  To confirm this, try:

DYLD_LIBRARY_PATH=/usr/local/pgsql/lib psql

and it should work. It's probably not a good idea to permanently set
your library path this way via the environment, google osx library
path.

merlin

Re: psql symbol lookup error

От
Rich Shepard
Дата:
On Tue, 14 Dec 2010, Merlin Moncure wrote:

> you have an older version of libpq in your library path, probably in
> /usr/lib.

Merlin,

   Sure enough.

> and it should work. It's probably not a good idea to permanently set
> your library path this way via the environment, google osx library
> path.

   OSX only works on Apple's stuff. Regardless, ... I still have to clean up
after upgrading from 8.3.3 in /var/lib/pgsql to 9.0.1 in /usr/local/pgsql.

   I've made softlinks from /usr/local/pgsql/lib/libpq.so.5.3 to
/usr/lib/libpq.so and /usr/lib/libpq.so.5. Still see issues:

[rshepard@salmo ~]$ psql aesi
psql: error while loading shared libraries: libpq.so.5: cannot open shared
object file: Permission denied

   Perms on the links /usr/lib/libpq.so.5 are 777 (owned by root.root); on
/usr/local/pgsql/ they are the same.

   Continued pointers to solutions appreciated.

Thanks,

Rich