Re: Need Support to Upgrade from 13.6 to 15.3

Jeff Janes <jeff.janes@gmail.com> writes:
> On Tue, May 16, 2023 at 5:07 AM Dippu Kumar <dippu.k@deeplynx.com> wrote:
>> /usr/lib/postgresql/15/bin/initdb -D /var/lib/postgresql/15/main
>> --auth-local peer --auth-host scram-sha-256 --no-instructions
>> /usr/lib/postgresql/15/bin/initdb: symbol lookup error:
>> /usr/lib/postgresql/15/bin/initdb: undefined symbol: PQmblenBounded

> I can't reproduce this.

This is pretty clearly a case of the initdb executable binding to
an old copy of libpq.so.  You could find out which one by running
"ldd /usr/lib/postgresql/15/bin/initdb".  Then, update that
installation to something released in the last two years.  Or
perhaps better, fix your dynamic linker search path so that it
finds the libpq.so that came with your v15 Postgres installation.

			regards, tom lane