Обсуждение: 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

On 2023-May-19, Dippu Kumar wrote:

> You suggested that I fix a dynamic linker but I always get some errors and
> finally I am stuck in a loop of these solutions.

What did you try to fix the dynamic linker?  Since you mentioned Ubuntu,
maybe look at /etc/ld.so.conf.d.  Also: maybe show the output of `ldd
/path/to/initdb` (for all versions of initdb).

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"I dream about dreams about dreams", sang the nightingale
under the pale moon (Sandman)

On 2023-May-23, Dippu Kumar wrote:

> =>>ldd for initdb
> ldd /usr/lib/postgresql/15/bin/initdb
>     linux-vdso.so.1 (0x00007ffe52231000)
>     libpq.so.5 => /usr/lib/x86_64-linux-gnu/libpq.so.5 (0x00007fddbb92d000)

Please run

dpkg -S /usr/lib/x86_64-linux-gnu/libpq.so.5
apt policy libpq5

and paste the output of both commands.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"Cuando mañana llegue pelearemos segun lo que mañana exija" (Mowgli)

On 2023-May-23, Dippu Kumar wrote:

> apt policy libpq5
> libpq5:
>   Installed: 2:13.10-1.bionic
>   Candidate: 2:13.10-1.bionic
>   Version table:
>  *** 2:13.10-1.bionic 500
>         500 http://repo.percona.com/ppg-13/apt bionic/main amd64 Packages
>         100 /var/lib/dpkg/status

So you seem to have a Percona repository enabled, and the libpq5 package
comes from there.  You need to ask Percona about this, not the Postgres
community -- or maybe get rid of the Percona repo completely, as it is
clearly breaking your system.

Also, maybe upgrade from Bionic.

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"The important things in the world are problems with society that we don't
understand at all. The machines will become more complicated but they won't
be more complicated than the societies that run them."    (Freeman Dyson)