Postgres Pro
Downloads
Home   >   mailing lists

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

psql command failing with error "undefined symbol: PQhostaddr"

From
Narendra katlamudi
Date:
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"

From
Osvaldo Kussama
Date:
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?

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

From
Pavel Stehule
Date:
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.


Regards

Pavel



thanks,
Narendra K

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

From
Adrian Klaver
Date:
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

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

From
Narendra katlamudi
Date:
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.


Regards

Pavel



thanks,
Narendra K