PostgreSQL Upgrade Issue - Undefined Symbol Error

On 8/15/24 04:03, Vivek Gadge wrote:

Hi All,

I am encountering an error after completion of PostgreSQL upgradation
from version 13.8 to 15.6. Trying to describe a single table, I am
receiving an error.

psql -d xyz

-->> \dt student*

The error message is as follows:

```
psql: symbol lookup error: psql: undefined symbol: PQmblenBounded
```

Could you please assist in resolving this issue?

Best bet you are using the 13.8 version of psql to work on 15.6 instance
of Postgres.

Do

psql -V

to verify what you are running.

Thanks and regards,

Vivek Gadge

--
Adrian Klaver
adrian.klaver@aklaver.com

Vivek Gadge <vvkgadge56@gmail.com> writes:

I am encountering an error after completion of PostgreSQL upgradation from
version 13.8 to 15.6. Trying to describe a single table, I am receiving an
error.

psql: symbol lookup error: psql: undefined symbol: PQmblenBounded

This indicates that your psql executable is linking to an old version
of libpq.so. (Running "ldd" on the psql file should confirm that.)
You may have a problem with the library search path being used by the
dynamic loader.

regards, tom lane