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

From Willian Colognesi
Subject Re: Segmentation Fault PG 14
Date
Msg-id CADAf1kb6R-qvCSDO3RpC+ze9LqABeoW87LcHsK3iHQW6hfvDLg@mail.gmail.com
Whole thread Raw
In response to Re: Segmentation Fault PG 14  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Segmentation Fault PG 14  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Segmentation Fault PG 14  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-general
Do you mean how it was compiled? the output of pg_config is it:
```
root@ip-10-x-x-x:/home/ubuntu# pg_config --configure
 '--build=aarch64-linux-gnu' '--prefix=/usr' '--includedir=${prefix}/include' '--mandir=${prefix}/share/man' '--infodir=${prefix}/share/info' '--sysconfdir=/etc' '--localstatedir=/var' '--disable-silent-rules' '--libdir=${prefix}/lib/aarch64-linux-gnu' '--runstatedir=/run' '--disable-maintainer-mode' '--disable-dependency-tracking' '--with-tcl' '--with-perl' '--with-python' '--with-pam' '--with-openssl' '--with-libxml' '--with-libxslt' '--mandir=/usr/share/postgresql/14/man' '--docdir=/usr/share/doc/postgresql-doc-14' '--sysconfdir=/etc/postgresql-common' '--datarootdir=/usr/share/' '--datadir=/usr/share/postgresql/14' '--bindir=/usr/lib/postgresql/14/bin' '--libdir=/usr/lib/aarch64-linux-gnu/' '--libexecdir=/usr/lib/postgresql/' '--includedir=/usr/include/postgresql/' '--with-extra-version= (Ubuntu 14.5-2.pgdg20.04+2)' '--enable-nls' '--enable-thread-safety' '--enable-debug' '--enable-dtrace' '--disable-rpath' '--with-uuid=e2fs' '--with-gnu-ld' '--with-gssapi' '--with-ldap' '--with-pgport=5432' '--with-system-tzdata=/usr/share/zoneinfo' 'AWK=mawk' 'MKDIR_P=/bin/mkdir -p' 'PROVE=/usr/bin/prove' 'PYTHON=/usr/bin/python3' 'TAR=/bin/tar' 'XSLTPROC=xsltproc --nonet' 'CFLAGS=-g -O2 -fstack-protector-strong -Wformat -Werror=format-security' 'LDFLAGS=-Wl,-Bsymbolic-functions -Wl,-z,relro -Wl,-z,now' '--enable-tap-tests' '--with-icu' '--with-llvm' 'LLVM_CONFIG=/usr/bin/llvm-config-10' 'CLANG=/usr/bin/clang-10' '--with-lz4' '--with-systemd' '--with-selinux' 'build_alias=aarch64-linux-gnu' 'CPPFLAGS=-Wdate-time -D_FORTIFY_SOURCE=2' 'CXXFLAGS=-g -O2 -fstack-protector-strong -Wformat -Werror=format-security'
```

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

On Mon, Nov 7, 2022 at 6:09 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Willian Colognesi <willian_colognesi@trimble.com> writes:
> No, the database is running well, no problem until now after disabled *jit.*

Interesting.  Which version of LLVM is installed?

                        regards, tom lane


--

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: Pilar de Teodoro
Date:
Subject: Re: postgres replication without pg_basebackup? postgres 13.3
Next
From: Tom Lane
Date:
Subject: Re: Segmentation Fault PG 14