Re: Segmentation Fault PG 14 - Mailing list pgsql-general

From Willian Colognesi
Subject Re: Segmentation Fault PG 14
Date
Msg-id CADAf1kbzxXiDJHj=7OQTjf44vncJaTgP=N7hXJkRrWo0bSv53w@mail.gmail.com
Whole thread Raw
In response to Re: Segmentation Fault PG 14  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-general
You are right Thomas,

Just confirmed and it's installed:

ubuntu@ip-10-x-x-x:~$ apt search llvm | grep inst
WARNING: apt does not have a stable CLI interface. Use with caution in scripts.
libllvm10/focal,now 1:10.0.0-4ubuntu1 arm64 [installed,automatic]

I was trying something like `llvm -version` or something like that but did not have success, but I verified, and in the apt is installed.

Tom,
Since yesterday the database hasn't restarted, so I'm believing that there is some problem related to jit.

On Tue, Nov 8, 2022 at 4:11 AM Thomas Munro <thomas.munro@gmail.com> wrote:
On Tue, Nov 8, 2022 at 11:45 AM Willian Colognesi
<willian_colognesi@trimble.com> wrote:
> root@ip-10-x-x-x:/home/ubuntu# pg_config --configure
> ... --with-extra-version= (Ubuntu 14.5-2.pgdg20.04+2)' ...
> ... '--with-llvm' 'LLVM_CONFIG=/usr/bin/llvm-config-10' ...

> There is no llvm installed on ubuntu server, postgresql was installed via apt package `apt install postgresql-14`

We can see from the pg_config output that it's built with LLVM 10.
Also that looks like it's the usual pgdg packages which are certainly
built against LLVM and will install it automatically.


--

Willian Cezar de O. Colognesi
Systems Analysis Specialist, Trimble Transportation Brazil
Avenida Santos Dumont, 271 | Londrina, PR | 86039-090

pgsql-general by date:

Previous
From: Cedric Aaron Towstyka
Date:
Subject: Information to CVE-2022-42889
Next
From: Erik Wienhold
Date:
Subject: Re: Information to CVE-2022-42889