Re: BUG #14897: Segfault on statitics SQL request

Here is the resut of pg_config:
$ pg_config
BINDIR = /usr/bin
DOCDIR = /usr/share/doc/postgresql
HTMLDIR = /usr/share/doc/postgresql
INCLUDEDIR = /usr/include
PKGINCLUDEDIR = /usr/include/postgresql
INCLUDEDIR-SERVER = /usr/include/postgresql/server
LIBDIR = /usr/lib
PKGLIBDIR = /usr/lib/postgresql
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/man
SHAREDIR = /usr/share/postgresql
SYSCONFDIR = /etc/postgresql
PGXS = /usr/lib/postgresql/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/usr' '--mandir=/usr/share/man'
'--datadir=/usr/share/postgresql' '--sysconfdir=/etc' '--with-gssapi'
'--with-libxml' '--with-openssl' '--with-pe
rl' '--with-python' 'PYTHON=/usr/bin/python2' '--with-tcl' '--with-pam'
'--with-system-tzdata=/usr/share/zoneinfo' '--with-uuid=e2fs'
'--enable-nls' '--enable-thread-s
afety' 'CFLAGS=-march=x86-64 -mtune=generic -O2 -pipe
-fstack-protector-strong -fno-plt'
'LDFLAGS=-Wl,-O1,--sort-common,--as-needed,-z,relro,-z,now'
'CPPFLAGS=-D_FORTI
FY_SOURCE=2'
CC = gcc
CPPFLAGS = -DFRONTEND -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE
-I/usr/include/libxml2
CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwr
apv -fexcess-precision=standard -march=x86-64 -mtune=generic -O2 -pipe
-fstack-protector-strong -fno-plt
CFLAGS_SL = -fPIC
LDFLAGS = -L../../src/common
-Wl,-O1,--sort-common,--as-needed,-z,relro,-z,now -Wl,--as-needed
-Wl,-rpath,'/usr/lib',--enable-new-dtags
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lpthread -lxml2 -lpam -lssl -lcrypto
-lgssapi_krb5 -lz -lreadline -lrt -lcrypt -ldl -lm
VERSION = PostgreSQL 10.1

If it is not help, I will recreate database and inject dump. It could be a
migration bug.
Archlinux does not provide debugging symbol package and my other computer
is under Gentoo (and it will take a long time to have a stable release). If
bug persists, I will open a bug on Archlinux bugtracker.

Regards.

Vincent

Le ven. 10 nov. 2017 à 21:46, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> a écrit :

> Vincent Lachenal <vincent(dot)lachenal(at)gmail(dot)com> writes:
> > The request returns this result on this database :
> > select name,setting,source from pg_settings where source != 'default';
>
> Hmm .... not much help there. I wonder if this is specific to ArchLinux.
> We do have an Arch machine in the buildfarm, but it's an ARM, so that
> might not prove much about Arch on other hardware.
>
> One other thing that might be useful: could you send the output of
> "pg_config" (that's a command-line program, not a SQL command)?
>
> regards, tom lane
>