From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jeff Janes <jeff.janes@gmail.com>
cc: Dippu Kumar <dippu.k@deeplynx.com>, pgsql-bugs@lists.postgresql.org
Subject: Re: Need Support to Upgrade from 13.6 to 15.3
In-reply-to: 
 <CAMkU=1wx0xkTH9ykKYGqG4is4jnf+Z8wJBdT-6f19YFmJ+7ArQ@mail.gmail.com>
References: 
 <CAF6fgVVk1pVBSYp20gxRrrTpK=cE1ECv-NrxtSQhjDeri=vziQ@mail.gmail.com>
 <CAMkU=1wx0xkTH9ykKYGqG4is4jnf+Z8wJBdT-6f19YFmJ+7ArQ@mail.gmail.com>
Comments: In-reply-to Jeff Janes <jeff.janes@gmail.com>
	message dated "Wed, 17 May 2023 19:43:47 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <3609319.1684367442.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Wed, 17 May 2023 19:50:42 -0400
Message-ID: <3609320.1684367442@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3609320.1684367442%40sss.pgh.pa.us>
Precedence: bulk

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