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

[Help][Service not coming-up]

From
Praveen Kumar K S
Date:
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

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

From
Dan Smith
Date:
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@gmail.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