psql command failing with error "undefined symbol: PQhostaddr"

2021-12-28 9:29 GMT-03:00, Narendra katlamudi <narendra_katlamudi@yahoo.co.in>:

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

thanks,Narendra K

Perhaps a typo?
PQHOSTADDR or PGHOSTADDR?

Hi

út 28. 12. 2021 v 13:29 odesílatel Narendra katlamudi <
narendra_katlamudi@yahoo.co.in> 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

On 12/28/21 04:29, Narendra katlamudi wrote:

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.

OS and version?

How where the Postgres versions installed?

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

thanks,
Narendra K

--
Adrian Klaver
adrian.klaver@aklaver.com

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@gmail.com> wrote:

Hi

út 28. 12. 2021 v 13:29 odesílatel Narendra katlamudi <narendra_katlamudi@yahoo.co.in> 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