Has anyone seen this error? I cannot login into my database.

P G <pg_dba@yahoo.com> writes:

I ran make for v7.3.2 successfully and ran the
regression tests successfully, but I keep getting the
following error when trying to log into my database.

psql: relocation error: psql: undefined symbol:
PQgetssl

I believe what you have here is an SSL-enabled psql that is linking to a
non-SSL-enabled libpq.so. You probably still have the old, not-SSL
libpq.so laying around, and you haven't updated ldconfig to know about
the new one. Check "ldd psql" to see what it shows the shared library
reference as resolving to ...

regards, tom lane

You're exactly correct. Thank you.

But now I may have a bigger problem, because I need
multiple versions of PostgreSQL to exist on a Cobalt
system and deleting the Cobalt PostgreSQL database is
not an option, because it makes administering the
system more difficult. So, how do I get psql to point
to the correct library? I am not sure I can simply
remove it and have the other database continue to
function correctly. I have already updated
/etc/ld.so.conf with the directory containing my
libraries for the alternate PostgreSQL database on the
system. pg_config --configure also shows the correct
--libdir.

TIA.

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:

P G <pg_dba@yahoo.com> writes:

I ran make for v7.3.2 successfully and ran the
regression tests successfully, but I keep getting

the

following error when trying to log into my

database.

psql: relocation error: psql: undefined symbol:
PQgetssl

I believe what you have here is an SSL-enabled psql
that is linking to a
non-SSL-enabled libpq.so. You probably still have
the old, not-SSL
libpq.so laying around, and you haven't updated
ldconfig to know about
the new one. Check "ldd psql" to see what it shows
the shared library
reference as resolving to ...

regards, tom lane

__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com