psql:relocation error:psql:unfefined symbol: PQgetssl

Started by Roberto Carrerover 23 years ago3 messagesgeneral
Jump to latest
#1Roberto Carrer
roberto@azserve.com

Hi all

I am a new postgresql user
I have installed version 7.3 on a Linux Red Hat 8.0 machine
I've used the configure script with the 2 options: --with-CXX --enable-odbc
I have the database running correctly in the foreground with the command:
./postmaster -D /datapath
but if I run it in the backgroud with the command:
./pg_ctl -D /datapath -l /tmp/pgsql.log start
the postmaster is running correctly and I can create a testdb database
but when I try to connect to it with the command:
psql testdb
I get the message:
psql:relocation error:psql:unfefined symbol: PQgetssl
and psql exits.

can anibody help me?

regards,

Roberto

#2Oliver Elphick
olly@lfix.co.uk
In reply to: Roberto Carrer (#1)
Re: psql:relocation error:psql:unfefined symbol: PQgetssl

On Tue, 2002-12-31 at 13:22, Roberto Carrer wrote:

I have installed version 7.3 on a Linux Red Hat 8.0 machine
I've used the configure script with the 2 options: --with-CXX --enable-odbc
I have the database running correctly in the foreground with the command:
./postmaster -D /datapath
but if I run it in the backgroud with the command:
./pg_ctl -D /datapath -l /tmp/pgsql.log start
the postmaster is running correctly and I can create a testdb database
but when I try to connect to it with the command:
psql testdb
I get the message:
psql:relocation error:psql:unfefined symbol: PQgetssl
and psql exits.

You haven't configured it to use ssl, but your psql seems to want it, so
it seems likely that you have a psql from some other source that is
using the libpq library you have just built and is not finding the
symbols that it wants.

Check which version of psql is being run (`which psql' or `type psql' or
`whereis psql'). Make sure your own version is found in the search path
before any other version.

--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"I love them that love me; and those that seek me early
shall find me." Proverbs 8:17

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Oliver Elphick (#2)
Re: psql:relocation error:psql:unfefined symbol: PQgetssl

Oliver Elphick <olly@lfix.co.uk> writes:

Check which version of psql is being run (`which psql' or `type psql' or
`whereis psql'). Make sure your own version is found in the search path
before any other version.

Also, check to see which copy of libpq it's finding ('ldd' will help
here). You may need to adjust your library search path to find the
right libpq (see 'ldconfig').

regards, tom lane