Re: psql command failing with error "undefined symbol: PQhostaddr"

[Narendra katlamudi <narendra_katlamudi@xxxxxxxxxxx>]

Hey Team,

Thanks for quick responses. But yeah, seems on my system Libpq.so* files were not present in the usual library path. 

After setting LD_LIBRARY_PATH to consider the location about libpg.so*, the psql  command started working.

thanks,

On Tuesday, 28 December, 2021, 06:23:30 pm IST, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:

Hi

út 28. 12. 2021 v 13:29 odesílatel Narendra katlamudi <narendra_katlamudi@xxxxxxxxxxx> napsal:

Hi Team

When I use psql to connect a pg server, I am getting below error. Any solution/pointers?

I have pg versions 11,12,13 installed on my system.

/usr/lib/postgresql/13/bin/psql: symbol lookup error: /usr/lib/postgresql/13/bin/psql: undefined symbol: PQhostaddr

Looks like a bad (too old) version of libpq library.

https://stackoverflow.com/questions/28123212/postgres-9-4-0-undefined-symbol-pqhostaddr

Regards

Pavel

thanks,

Narendra K