Re: libpq related crash
От | Guillaume Lelarge |
---|---|
Тема | Re: libpq related crash |
Дата | |
Msg-id | 4C760034.1080202@lelarge.info обсуждение исходный текст |
Ответ на | libpq related crash (Ramanujam <innomotive@gmail.com>) |
Ответы |
Re: libpq related crash
(Ramanujam <innomotive@gmail.com>)
|
Список | pgadmin-hackers |
Le 26/08/2010 07:35, Ramanujam a écrit : > [...] > I apologise if this is the incorrect list. > You won't need to, it is the correct list :) > I successfully built the latest pgAdmin3 source from git. However, > when I try to connect a a db after launching, I get the following > error: > > ./pgadmin3: symbol lookup error: ./pgadmin3: undefined symbol: PQconninfoParse > > I did refer to the previous thread that carried this exact error and > checked if I am indeed building against a libpq 8.4+ version. > "configure" confirms this: > ... > checking for PQexec in -lpq... yes > checking for PQconninfoParse in -lpq... yes > checking for SSL_connect in -lpq... no > ... > > PostgreSQL directory: /usr/local/pgsql > PostgreSQL pg_config binary: /usr/local/pgsql/bin/pg_config > PostgreSQL version: PostgreSQL 8.4.4 > PostgreSQL SSL support: Missing > > I did have a 8.3 version before but I have removed that including any > remnants of it. I am running an 8.4.4 and can connect to it without > problems from psql: > > kono@yam:~/pg/pgadmin/pgadmin3$ /usr/local/pgsql/bin/psql -U postgres test3 > psql (8.4.4) > Type "help" for help. > > test3=# select version(); > version > -------------------------------------------------------------------------------------------------- > PostgreSQL 8.4.4 on i686-pc-linux-gnu, compiled by GCC gcc (Ubuntu > 4.3.3-5ubuntu4) 4.3.3, 32-bit > (1 row) > > test3=# \set > ... > VERSION = 'PostgreSQL 8.4.4 on i686-pc-linux-gnu, compiled by GCC gcc > (Ubuntu 4.3.3-5ubuntu4) 4.3.3, 32-bit' > DBNAME = 'test3' > USER = 'postgres' > PORT = '5432' > ENCODING = 'UTF8' > > Can anyone please let me know how this can be resolved? > I'm pretty sure you have an old libpq library around, and that pgAdmin uses this one. Be careful that libpq is a different package on Ubuntu (I mean, not a postgresql-*, but a libpq*). Try "ldd $(which pgadmin3) | grep libpq" to find which one library file it uses. To launch pgAdmin, you can try this on a terminal: export LD_LIBRARY_PATH=/usr/local/pgsql/lib:$LD_LIBRARY_PATH pgadmin3 After the export, if /usr/local/pgsql is the location of your 8.4 PostgreSQL binaires, then pgAdmin should connect to your databases if you launch if from the same terminal. Tell us how it goes. I have probably to work on this today, and I would like to hear from you so that we get the best fix. Thanks. -- Guillaume http://www.postgresql.fr http://dalibo.com
В списке pgadmin-hackers по дате отправления: