pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedNeed Support to Upgrade from 13.6 to 15.3
10+ messages / 4 participants
[nested] [flat]
* Need Support to Upgrade from 13.6 to 15.3
@ 2023-05-16 08:58 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-17 23:43 ` Re: Need Support to Upgrade from 13.6 to 15.3 Jeff Janes <jeff.janes@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: Dippu Kumar @ 2023-05-16 08:58 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org
Dear Support Team,
I'm facing an issue while upgrading PostgreSQL from version 13.6 to 15.3.
Here are steps I'm following:
- I hosted my existing PostgreSQL 13.6 instance on AWS (Ubuntu)
- I create an instance using AMIs ( same image of hosted instance )
- I run the below command after a few steps , I face initdb issue
sudo apt install postgresql
I need your help here.
sudo pg_createcluster 15 main --start
Creating new PostgreSQL cluster 15/main ...
/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
Error: initdb failed
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Need Support to Upgrade from 13.6 to 15.3
2023-05-16 08:58 Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
@ 2023-05-17 23:43 ` Jeff Janes <jeff.janes@gmail.com>
2023-05-17 23:50 ` Re: Need Support to Upgrade from 13.6 to 15.3 Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 10+ messages in thread
From: Jeff Janes @ 2023-05-17 23:43 UTC (permalink / raw)
To: Dippu Kumar <dippu.k@deeplynx.com>; +Cc: pgsql-bugs@lists.postgresql.org
On Tue, May 16, 2023 at 5:07 AM Dippu Kumar <dippu.k@deeplynx.com> wrote:
> Dear Support Team,
> - I run the below command after a few steps , I face initdb issue
> sudo apt install postgresql
>
> sudo pg_createcluster 15 main --start
>
> Creating new PostgreSQL cluster 15/main ...
>
> /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
>
> Error: initdb failed
>
I can't reproduce this. What release of Ubuntu are you using? (Maybe what
specific API?) What machine type? What repository are you installing from?
(I don't think any Ubuntu is coming with PostgreSQL v15 right now by
default from the default repo). Do you have to have already installed v13
first before you get this problem?
Cheers,
Jeff
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Need Support to Upgrade from 13.6 to 15.3
2023-05-16 08:58 Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-17 23:43 ` Re: Need Support to Upgrade from 13.6 to 15.3 Jeff Janes <jeff.janes@gmail.com>
@ 2023-05-17 23:50 ` Tom Lane <tgl@sss.pgh.pa.us>
2023-05-19 13:25 ` Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
0 siblings, 1 reply; 10+ messages in thread
From: Tom Lane @ 2023-05-17 23:50 UTC (permalink / raw)
To: Jeff Janes <jeff.janes@gmail.com>; +Cc: Dippu Kumar <dippu.k@deeplynx.com>; pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Need Support to Upgrade from 13.6 to 15.3
2023-05-16 08:58 Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-17 23:43 ` Re: Need Support to Upgrade from 13.6 to 15.3 Jeff Janes <jeff.janes@gmail.com>
2023-05-17 23:50 ` Re: Need Support to Upgrade from 13.6 to 15.3 Tom Lane <tgl@sss.pgh.pa.us>
@ 2023-05-19 13:25 ` Dippu Kumar <dippu.k@deeplynx.com>
2023-05-23 08:48 ` Re: Need Support to Upgrade from 13.6 to 15.3 Alvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 1 reply; 10+ messages in thread
From: Dippu Kumar @ 2023-05-19 13:25 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Jeff Janes <jeff.janes@gmail.com>; pgsql-bugs@lists.postgresql.org
Hello Tom Lane,
Thank you for your response! I really appreciate it.
I don't know why I couldn't make it well. I got tired after doing many
approaches.
I tried 3 approaches for this :
*Approach 1* :
I tried with a new instance installed postgresql version 13 then created
some test DB, and inserts a few data into a table. Then update version 15,
I can see all data - *Succeed*
*Approach 2 *:
I tried with a new instance installed postgresql version 13 then created an
Image of this instance and launched a new instance using this image (AMIs).
Then update version 15, I can see all data of version 13 - *Succeed*
*Approach 3 : *
I launch a new instance using the latest image of our postgresql
instance. Then update version 15, it shows error - *Failed*
=> Reasons or error :
/usr/lib/postgresql/15/bin/pg_upgrade: symbol lookup error:
/usr/lib/postgresql/15/bin/pg_upgrade: undefined symbol: PQmblenBounded
- Always get *PQmblenBounded *error whenever I try to execute
postgresql binary.
*Information:*
* -* I'm using Postgresql 13.6 which is hosted on Ubuntu ( 18.04.6 LTS,
Codename : bionic)
- DB Data is more than 650 GB so I can't go with *pgdump *option
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.
If I try to fix one another problem come up.
Please suggest steps to complete this task.I'm writing to you as a last
option, I stopped searching on google.
*Thanks & Regards*
*Dippu*
On Thu, May 18, 2023 at 5:20 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Need Support to Upgrade from 13.6 to 15.3
2023-05-16 08:58 Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-17 23:43 ` Re: Need Support to Upgrade from 13.6 to 15.3 Jeff Janes <jeff.janes@gmail.com>
2023-05-17 23:50 ` Re: Need Support to Upgrade from 13.6 to 15.3 Tom Lane <tgl@sss.pgh.pa.us>
2023-05-19 13:25 ` Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
@ 2023-05-23 08:48 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
2023-05-23 09:20 ` Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
0 siblings, 1 reply; 10+ messages in thread
From: Alvaro Herrera @ 2023-05-23 08:48 UTC (permalink / raw)
To: Dippu Kumar <dippu.k@deeplynx.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Jeff Janes <jeff.janes@gmail.com>; pgsql-bugs@lists.postgresql.org
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)
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Need Support to Upgrade from 13.6 to 15.3
2023-05-16 08:58 Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-17 23:43 ` Re: Need Support to Upgrade from 13.6 to 15.3 Jeff Janes <jeff.janes@gmail.com>
2023-05-17 23:50 ` Re: Need Support to Upgrade from 13.6 to 15.3 Tom Lane <tgl@sss.pgh.pa.us>
2023-05-19 13:25 ` Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-23 08:48 ` Re: Need Support to Upgrade from 13.6 to 15.3 Alvaro Herrera <alvherre@alvh.no-ip.org>
@ 2023-05-23 09:20 ` Dippu Kumar <dippu.k@deeplynx.com>
2023-05-23 09:28 ` Re: Need Support to Upgrade from 13.6 to 15.3 Alvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 1 reply; 10+ messages in thread
From: Dippu Kumar @ 2023-05-23 09:20 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@alvh.no-ip.org>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Jeff Janes <jeff.janes@gmail.com>; pgsql-bugs@lists.postgresql.org
Thank you for your response!
I've attached what you asked for.PFA.
I tried every possible way but couldn't make it.
Whatever I do it's always pointing me to '*undefined symbol: PQmblenBounded*'.
So it's kind of loop of problems where I stucked.
On Tue, May 23, 2023 at 2:18 PM Alvaro Herrera <alvherre@alvh.no-ip.org>
wrote:
> 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)
>
Attachments:
response.txt (text/plain, 5.2K) download
=> Try to fix libpx but got erro
sudo apt-get install libpq-dev
Reading package lists... Done
Building dependency tree
Reading state information... Done
libpq-dev is already the newest version (2:13.10-1.bionic).
The following packages were automatically installed and are no longer required:
libc-ares2 libllvm11 linux-aws-5.4-headers-5.4.0-1072 linux-aws-5.4-headers-5.4.0-1075 linux-aws-5.4-headers-5.4.0-1078 linux-aws-5.4-headers-5.4.0-1080 linux-aws-5.4-headers-5.4.0-1081 linux-aws-5.4-headers-5.4.0-1083 linux-aws-5.4-headers-5.4.0-1084
linux-aws-5.4-headers-5.4.0-1085 linux-aws-5.4-headers-5.4.0-1086 linux-aws-5.4-headers-5.4.0-1088 linux-aws-5.4-headers-5.4.0-1089 linux-aws-5.4-headers-5.4.0-1092 linux-aws-5.4-headers-5.4.0-1093 linux-aws-5.4-headers-5.4.0-1094 linux-aws-5.4-headers-5.4.0-1097
linux-aws-5.4-headers-5.4.0-1099 pgdg-keyring
Use 'sudo apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 34 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] y
Setting up postgresql-15 (15.3-1.pgdg18.04+1) ...
Creating new PostgreSQL cluster 15/main ...
/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
Error: initdb failed
Error: could not create default cluster. Please create it manually with
pg_createcluster 15 main --start
or a similar command (see 'man pg_createcluster').
/var/lib/dpkg/info/postgresql-15.postinst: 104: /var/lib/dpkg/info/postgresql-15.postinst: db_stop: not found
dpkg: error processing package postgresql-15 (--configure):
installed postgresql-15 package post-installation script subprocess returned error exit status 127
Errors were encountered while processing:
postgresql-15
E: Sub-process /usr/bin/dpkg returned an error code (1)
=> vim /etc/ld.so.conf.d
./
libc.conf
x86_64-linux-gnu.conf
=>>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)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007fddbb70e000)
librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007fddbb506000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007fddbb168000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fddbad77000)
libssl.so.1.1 => /usr/lib/x86_64-linux-gnu/libssl.so.1.1 (0x00007fddbaaea000)
libcrypto.so.1.1 => /usr/lib/x86_64-linux-gnu/libcrypto.so.1.1 (0x00007fddba61e000)
libgssapi_krb5.so.2 => /usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2 (0x00007fddba3d3000)
libldap_r-2.4.so.2 => /usr/lib/x86_64-linux-gnu/libldap_r-2.4.so.2 (0x00007fddba181000)
/lib64/ld-linux-x86-64.so.2 (0x00007fddbbda8000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007fddb9f7d000)
libkrb5.so.3 => /usr/lib/x86_64-linux-gnu/libkrb5.so.3 (0x00007fddb9ca7000)
libk5crypto.so.3 => /usr/lib/x86_64-linux-gnu/libk5crypto.so.3 (0x00007fddb9a75000)
libcom_err.so.2 => /lib/x86_64-linux-gnu/libcom_err.so.2 (0x00007fddb9871000)
libkrb5support.so.0 => /usr/lib/x86_64-linux-gnu/libkrb5support.so.0 (0x00007fddb9666000)
liblber-2.4.so.2 => /usr/lib/x86_64-linux-gnu/liblber-2.4.so.2 (0x00007fddb9458000)
libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007fddb923e000)
libsasl2.so.2 => /usr/lib/x86_64-linux-gnu/libsasl2.so.2 (0x00007fddb9023000)
libgssapi.so.3 => /usr/lib/x86_64-linux-gnu/libgssapi.so.3 (0x00007fddb8de2000)
libgnutls.so.30 => /usr/lib/x86_64-linux-gnu/libgnutls.so.30 (0x00007fddb8a7c000)
libkeyutils.so.1 => /lib/x86_64-linux-gnu/libkeyutils.so.1 (0x00007fddb8878000)
libheimntlm.so.0 => /usr/lib/x86_64-linux-gnu/libheimntlm.so.0 (0x00007fddb866f000)
libkrb5.so.26 => /usr/lib/x86_64-linux-gnu/libkrb5.so.26 (0x00007fddb83e2000)
libasn1.so.8 => /usr/lib/x86_64-linux-gnu/libasn1.so.8 (0x00007fddb8140000)
libhcrypto.so.4 => /usr/lib/x86_64-linux-gnu/libhcrypto.so.4 (0x00007fddb7f0a000)
libroken.so.18 => /usr/lib/x86_64-linux-gnu/libroken.so.18 (0x00007fddb7cf4000)
libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007fddb7ad7000)
libp11-kit.so.0 => /usr/lib/x86_64-linux-gnu/libp11-kit.so.0 (0x00007fddb77a8000)
libidn2.so.0 => /usr/lib/x86_64-linux-gnu/libidn2.so.0 (0x00007fddb758b000)
libunistring.so.2 => /usr/lib/x86_64-linux-gnu/libunistring.so.2 (0x00007fddb720d000)
libtasn1.so.6 => /usr/lib/x86_64-linux-gnu/libtasn1.so.6 (0x00007fddb6ffa000)
libnettle.so.6 => /usr/lib/x86_64-linux-gnu/libnettle.so.6 (0x00007fddb6dc4000)
libhogweed.so.4 => /usr/lib/x86_64-linux-gnu/libhogweed.so.4 (0x00007fddb6b8e000)
libgmp.so.10 => /usr/lib/x86_64-linux-gnu/libgmp.so.10 (0x00007fddb690d000)
libwind.so.0 => /usr/lib/x86_64-linux-gnu/libwind.so.0 (0x00007fddb66e4000)
libheimbase.so.1 => /usr/lib/x86_64-linux-gnu/libheimbase.so.1 (0x00007fddb64d5000)
libhx509.so.5 => /usr/lib/x86_64-linux-gnu/libhx509.so.5 (0x00007fddb628b000)
libsqlite3.so.0 => /usr/lib/x86_64-linux-gnu/libsqlite3.so.0 (0x00007fddb5f82000)
libcrypt.so.1 => /lib/x86_64-linux-gnu/libcrypt.so.1 (0x00007fddb5d4a000)
libffi.so.6 => /usr/lib/x86_64-linux-gnu/libffi.so.6 (0x00007fddb5b42000)
* Re: Need Support to Upgrade from 13.6 to 15.3
2023-05-16 08:58 Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-17 23:43 ` Re: Need Support to Upgrade from 13.6 to 15.3 Jeff Janes <jeff.janes@gmail.com>
2023-05-17 23:50 ` Re: Need Support to Upgrade from 13.6 to 15.3 Tom Lane <tgl@sss.pgh.pa.us>
2023-05-19 13:25 ` Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-23 08:48 ` Re: Need Support to Upgrade from 13.6 to 15.3 Alvaro Herrera <alvherre@alvh.no-ip.org>
2023-05-23 09:20 ` Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
@ 2023-05-23 09:28 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
2023-05-23 09:31 ` Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
0 siblings, 1 reply; 10+ messages in thread
From: Alvaro Herrera @ 2023-05-23 09:28 UTC (permalink / raw)
To: Dippu Kumar <dippu.k@deeplynx.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Jeff Janes <jeff.janes@gmail.com>; pgsql-bugs@lists.postgresql.org
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)
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Need Support to Upgrade from 13.6 to 15.3
2023-05-16 08:58 Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-17 23:43 ` Re: Need Support to Upgrade from 13.6 to 15.3 Jeff Janes <jeff.janes@gmail.com>
2023-05-17 23:50 ` Re: Need Support to Upgrade from 13.6 to 15.3 Tom Lane <tgl@sss.pgh.pa.us>
2023-05-19 13:25 ` Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-23 08:48 ` Re: Need Support to Upgrade from 13.6 to 15.3 Alvaro Herrera <alvherre@alvh.no-ip.org>
2023-05-23 09:20 ` Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-23 09:28 ` Re: Need Support to Upgrade from 13.6 to 15.3 Alvaro Herrera <alvherre@alvh.no-ip.org>
@ 2023-05-23 09:31 ` Dippu Kumar <dippu.k@deeplynx.com>
2023-05-23 09:45 ` Re: Need Support to Upgrade from 13.6 to 15.3 Alvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 1 reply; 10+ messages in thread
From: Dippu Kumar @ 2023-05-23 09:31 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@alvh.no-ip.org>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Jeff Janes <jeff.janes@gmail.com>; pgsql-bugs@lists.postgresql.org
Here are:
=>>
dpkg -S /usr/lib/x86_64-linux-gnu/libpq.so.5
libpq5:amd64: /usr/lib/x86_64-linux-gnu/libpq.so.5
=>>
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
2:13.9-1.bionic 500
500 http://repo.percona.com/ppg-13/apt bionic/main amd64 Packages
2:13.8-3.bionic 500
500 http://repo.percona.com/ppg-13/apt bionic/main amd64 Packages
2:13.7-3.bionic 500
500 http://repo.percona.com/ppg-13/apt bionic/main amd64 Packages
2:13.6-3.bionic 500
500 http://repo.percona.com/ppg-13/apt bionic/main amd64 Packages
15.3-1.pgdg18.04+1 500
500 http://apt.postgresql.org/pub/repos/apt bionic-pgdg/main amd64
Packages
10.23-0ubuntu0.18.04.1 500
500 http://ap-southeast-1.ec2.archive.ubuntu.com/ubuntu
bionic-updates/main amd64 Packages
10.22-0ubuntu0.18.04.1 500
500 http://security.ubuntu.com/ubuntu bionic-security/main amd64
Packages
10.3-1 500
500 http://ap-southeast-1.ec2.archive.ubuntu.com/ubuntu bionic/main
amd64 Packages
On Tue, May 23, 2023 at 2:58 PM Alvaro Herrera <alvherre@alvh.no-ip.org>
wrote:
> 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)
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Need Support to Upgrade from 13.6 to 15.3
2023-05-16 08:58 Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-17 23:43 ` Re: Need Support to Upgrade from 13.6 to 15.3 Jeff Janes <jeff.janes@gmail.com>
2023-05-17 23:50 ` Re: Need Support to Upgrade from 13.6 to 15.3 Tom Lane <tgl@sss.pgh.pa.us>
2023-05-19 13:25 ` Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-23 08:48 ` Re: Need Support to Upgrade from 13.6 to 15.3 Alvaro Herrera <alvherre@alvh.no-ip.org>
2023-05-23 09:20 ` Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-23 09:28 ` Re: Need Support to Upgrade from 13.6 to 15.3 Alvaro Herrera <alvherre@alvh.no-ip.org>
2023-05-23 09:31 ` Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
@ 2023-05-23 09:45 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
2023-05-23 11:20 ` Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
0 siblings, 1 reply; 10+ messages in thread
From: Alvaro Herrera @ 2023-05-23 09:45 UTC (permalink / raw)
To: Dippu Kumar <dippu.k@deeplynx.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Jeff Janes <jeff.janes@gmail.com>; pgsql-bugs@lists.postgresql.org
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)
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Need Support to Upgrade from 13.6 to 15.3
2023-05-16 08:58 Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-17 23:43 ` Re: Need Support to Upgrade from 13.6 to 15.3 Jeff Janes <jeff.janes@gmail.com>
2023-05-17 23:50 ` Re: Need Support to Upgrade from 13.6 to 15.3 Tom Lane <tgl@sss.pgh.pa.us>
2023-05-19 13:25 ` Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-23 08:48 ` Re: Need Support to Upgrade from 13.6 to 15.3 Alvaro Herrera <alvherre@alvh.no-ip.org>
2023-05-23 09:20 ` Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-23 09:28 ` Re: Need Support to Upgrade from 13.6 to 15.3 Alvaro Herrera <alvherre@alvh.no-ip.org>
2023-05-23 09:31 ` Re: Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-23 09:45 ` Re: Need Support to Upgrade from 13.6 to 15.3 Alvaro Herrera <alvherre@alvh.no-ip.org>
@ 2023-05-23 11:20 ` Dippu Kumar <dippu.k@deeplynx.com>
0 siblings, 0 replies; 10+ messages in thread
From: Dippu Kumar @ 2023-05-23 11:20 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@alvh.no-ip.org>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Jeff Janes <jeff.janes@gmail.com>; pgsql-bugs@lists.postgresql.org
I really appreciate your help!
Please provide me with steps to do this.
Will it impact my existing data (+ 650 GB) and compatibility?
On Tue, May 23, 2023 at 3:15 PM Alvaro Herrera <alvherre@alvh.no-ip.org>
wrote:
> 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)
>
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2023-05-23 11:20 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-05-16 08:58 Need Support to Upgrade from 13.6 to 15.3 Dippu Kumar <dippu.k@deeplynx.com>
2023-05-17 23:43 ` Jeff Janes <jeff.janes@gmail.com>
2023-05-17 23:50 ` Tom Lane <tgl@sss.pgh.pa.us>
2023-05-19 13:25 ` Dippu Kumar <dippu.k@deeplynx.com>
2023-05-23 08:48 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
2023-05-23 09:20 ` Dippu Kumar <dippu.k@deeplynx.com>
2023-05-23 09:28 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
2023-05-23 09:31 ` Dippu Kumar <dippu.k@deeplynx.com>
2023-05-23 09:45 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
2023-05-23 11:20 ` Dippu Kumar <dippu.k@deeplynx.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox