Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
P G
Date:
Linux kernel:  2.4.18-3
PostgreSQL:  7.3.2

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.
Will someone tell me what this is and how to fix it?

$ psql -d template1
Welcome to psql 7.3.2, the PostgreSQL interactive
terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

psql: relocation error: psql: undefined symbol:
PQgetssl
$

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

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

From
Tom Lane
Date:
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

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

From
P G
Date:
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