Re: Segmentation Fault PG 14

Looks like we can confirm that the jit disable fixed the problem, because
since yesterday when I disabled jit, the database did not restarted again,
and before it the database was restarting at least once per hour.

I don't think it will cause too much impact in our use case having it
disabled, so, if you need anything else that could help the analyses to
find the bug feel free to let me know and I can grab the logs or whatever
needed.

Thanks y'all

On Mon, Nov 7, 2022 at 8:05 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Willian Colognesi <willian_colognesi(at)trimble(dot)com> writes:
> > There is no llvm installed on ubuntu server, postgresql was installed via
> > apt package `apt install postgresql-14`
>
> If there's no LLVM around, then disabling JIT wouldn't do anything,
> because it depends on LLVM to compile code.
>
> We should perhaps wait awhile to see if that really fixed it.
>
> regards, tom lane
>

--
<http://www.trimble.com/>

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