Re: [Help][Service not coming-up]

From: Dan Smith <j(dot)daniel(dot)smith1(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [Help][Service not coming-up]
Date: 2022-02-07 13:14:30
Message-ID: CAK50JrwGDW7MY2hB9PUz-5Z0ccHVEpnc25iEmzygZhMMaRT=AA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

FYI, v9.6 received it's final update in November 2021. Reference:
https://www postgresql.org/support/versioning/

My assumption would be that you would need to add a apt source that
contained the 9.6 library and/or upgrade postgres to a supported version.

According to https://www.postgresql.org/download/linux/ubuntu/ the new
default version of
PostgreSQL is v12 for Ubuntu. I would recommend trying to adding the
official apt repo from the before mentioned link and upgrading to a
supported version of server, client and driver.

Best regards,

Dan Smith

On Mon, Feb 7, 2022, 07:35 Praveen Kumar K S <praveenssit(at)gmail(dot)com> wrote:

> Hello,
>
> I have postgresql 9.6 running on Ubuntu server 16. After upgrading it to
> 18, it was running fine. And I upgraded to 20, the service is not coming
> up. Below is the error seen in logs. I have debezium configured and even
> tried compiling it again on 20. But it did not help.
>
> FATAL: could not load library "/usr/lib/postgresql/9.6/lib/decoderbufs.so": /usr/lib/x86_64-linux-gnu/libSFCGAL.so.1: undefined symbol: _ZlsRSoPK12__mpz_struct
>
>
> --
>
>
> *Regards,*
>
>
> *K S Praveen Kumar*
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2022-02-07 16:09:20 Re: autovacuum default run with vacuum_index_cleanup and vacuum_truncate and related lock?
Previous Message Nikhil Shetty 2022-02-07 12:45:49 Re: Lost replication slots after pg_upgrade.