psql command failing with error "undefined symbol: PQhostaddr"

2021-12-28 Thread Narendra katlamudi 
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

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

2021-12-29 Thread Narendra katlamudi 
 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 
 wrote:  
 
 Hi

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