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