Package: postgresql-15
Version: 15.0-1.pgdg18.04+1
Severity: normal

PostgreSQL 15 includes a new wal_compression option, "zstd", which requires the
--with-zstd build option. When installing on Ubuntu 18.04 from the APT package
on http://apt.postgresql.org/pub/repos/apt/ the server fails to start with
wal_compression: zstd and logs the following:

2022-11-04 09:57:36.835 UTC [10886] LOG:  invalid value for parameter
"wal_compression": "zstd"
2022-11-04 09:57:36.835 UTC [10886] HINT:  Available values: pglz, lz4, on,
off.

Confirming that it was compiled without --with-zstd:

SELECT version(), name, setting FROM pg_config() WHERE name='CONFIGURE';

"PostgreSQL 15.0 (Ubuntu 15.0-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled
by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit"
" '--build=x86_64-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/x86_64-linux-gnu' '--
libexecdir=${prefix}/lib/x86_64-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/15/man' '--docdir=/usr/share/doc/postgresql-
doc-15' '--sysconfdir=/etc/postgresql-common' '--datarootdir=/usr/share/' '--
datadir=/usr/share/postgresql/15' '--bindir=/usr/lib/postgresql/15/bin' '--
libdir=/usr/lib/x86_64-linux-gnu/' '--libexecdir=/usr/lib/postgresql/' '--
includedir=/usr/include/postgresql/' '--with-extra-version= (Ubuntu
15.0-1.pgdg18.04+1)' '--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 -fno-omit-frame-pointer' 'LDFLAGS=-Wl,-Bsymbolic-
functions -Wl,-z,relro -Wl,-z,now' '--enable-tap-tests' '--with-icu' '--with-
llvm' 'LLVM_CONFIG=/usr/bin/llvm-config-6.0' 'CLANG=/usr/bin/clang-6.0' '--
with-lz4' '--with-systemd' '--with-selinux' 'build_alias=x86_64-linux-gnu'
'CPPFLAGS=-Wdate-time -D_FORTIFY_SOURCE=2' 'CXXFLAGS=-g -O2 -fstack-protector-
strong -Wformat -Werror=format-security'"

Please compile it with --with-zstd so ZStandard WAL compression can be used.

(Note: reportbug is being run on a different machine - please ignore the
"system information".)



-- System Information:
Debian Release: bullseye/sid
  APT prefers focal-updates
  APT policy: (500, 'focal-updates'), (500, 'focal-security'), (500, 'focal'), 
(100, 'focal-backports')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 5.4.0-131-generic (SMP w/4 CPU cores)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US 
(charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Reply via email to