Re: postgis for beta releases

Hmm

I think this is being evaluated as "0" for rhel, so needs to test for
suse_version > 0.

https://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob;f=rpm/redhat/main/non-common/postgresql-15/main/postgresql-15.spec;h=7da2dbc72f1cdee8003c7d71b6ccead89adc85ce;hb=3a5d4584b9c18de8c42d172032c01bfe948c8167
640 %if 0%{?suse_version} <= 1315
641 %else
642 --with-zstd \
643 %endif

postgresql15-15.0-beta1_PGDG.rhel7.x86_64

ts=# SELECT version(), setting FROM pg_config() WHERE name='CONFIGURE';
version|PostgreSQL 15beta1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit
setting| '--enable-rpath' '--prefix=/usr/pgsql-15' '--includedir=/usr/pgsql-15/include' '--mandir=/usr/pgsql-15/share/man' '--datadir=/usr/pgsql-15/share' '--libdir=/usr/pgsql-15/lib' '--with-lz4' '--enable-debug' '--enable-cassert' '--with-icu' '--with-llvm' '--with-perl' '--with-python' '--with-tcl' '--with-tclconfig=/usr/lib64' '--with-openssl' '--with-pam' '--with-gssapi' '--with-includes=/usr/include' '--with-libraries=/usr/lib64' '--enable-nls' '--enable-dtrace' '--with-uuid=e2fs' '--with-libxml' '--with-libxslt' '--with-ldap' '--with-selinux' '--with-systemd' '--with-system-tzdata=/usr/share/zoneinfo' '--sysconfdir=/etc/sysconfig/pgsql' '--docdir=/usr/pgsql-15/doc' '--htmldir=/usr/pgsql-15/doc/html' 'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic' 'LLVM_CONFIG=/usr/lib64/llvm5.0/bin/llvm-config' 'CLANG=/opt/rh/llvm-toolset-7/root/usr/bin/clang' 'PKG_CONFIG_PATH=:/usr/lib64/pkgconfig:/usr/share/pkgconfig' 'PYTHON=/usr/bin/python3'

postgres=# SET wal_compression =zstd;
ERROR: invalid value for parameter "wal_compression": "zstd"
HINT: Available values: pglz, lz4, on, off.

[pryzbyj(at)template0 ~]$ sudo rpm -e libzstd-1.5.2-1.el7.x86_64
error: Failed dependencies:
libzstd >= 1.4.0 is needed by (installed) postgresql15-15.0-beta1_PGDG.rhel7.x86_64

On Mon, May 23, 2022 at 09:11:00PM +0100, Devrim Gündüz wrote:
> Hi,
>
> On Thu, 2022-05-19 at 11:16 -0500, Justin Pryzby wrote:
> >
> > Also, could you build v15 with --enable-zstd ?
>
> commit 1bd03ce822dea86438ae538bdbd39600359c0133
> Author: Devrim Gündüz <devrim(at)gunduz(dot)org>
> Date: Thu Mar 31 12:19:30 2022 +0100
> --
> PostgreSQL 15: Compile with --with-zstd to support zstd compression
> of full-page writes in WAL

--
Justin Pryzby
System Administrator
Telsasoft
+1-952-707-8581