Re: postgis for beta releases - Mailing list pgsql-pkg-yum

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@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@gunduz.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