Date: Mon, 23 May 2022 15:42:03 -0500
From: Justin Pryzby <pryzby@telsasoft.com>
To: Devrim =?iso-8859-1?B?R/xuZPx6?= <devrim@gunduz.org>
Cc: Paul Ramsey <pramsey@cleverelephant.ca>,
	Christoph Berg <myon@debian.org>, pgsql-pkg-yum@postgresql.org
Subject: Re: postgis for beta releases
Message-ID: <20220523204203.GE19626@telsasoft.com>
References: <20210520163737.GA18818@telsasoft.com>
 <YKa6IvpedYeq5c9q@msg.df7cb.de>
 <YKa6VDK/N+KvpAlx@msg.df7cb.de>
 <CAB7C0F0-B240-4D37-A1D4-B6918EAB1BA7@cleverelephant.ca>
 <20210601233925.GD2082@telsasoft.com>
 <e91348ff1c929ba2b127d11ec511a76dc67170af.camel@gunduz.org>
 <20210816223804.GF10479@telsasoft.com>
 <ef40bcdcb10762346be99cc6ed8d5a8fa4f02f8d.camel@gunduz.org>
 <20220519161601.GQ19626@telsasoft.com>
 <7ffbe55cc548f956864e60fca19067d6d539b623.camel@gunduz.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
In-Reply-To: <7ffbe55cc548f956864e60fca19067d6d539b623.camel@gunduz.org>
User-Agent: Mutt/1.9.4 (2018-02-28)
Archived-At: 
 <https://www.postgresql.org/message-id/20220523204203.GE19626%40telsasoft.com>
Precedence: bulk

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=3Dpgrpms.git;a=3Dblob;f=3Drpm/redhat/m=
ain/non-common/postgresql-15/main/postgresql-15.spec;h=3D7da2dbc72f1cdee800=
3c7d71b6ccead89adc85ce;hb=3D3a5d4584b9c18de8c42d172032c01bfe948c8167
 640 %if 0%{?suse_version} <=3D 1315
 641 %else
 642         --with-zstd \
 643 %endif

postgresql15-15.0-beta1_PGDG.rhel7.x86_64

ts=3D# SELECT version(), setting FROM pg_config() WHERE name=3D'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=3D/usr/pgsql-15' '--includedir=3D/usr/p=
gsql-15/include' '--mandir=3D/usr/pgsql-15/share/man' '--datadir=3D/usr/pgs=
ql-15/share' '--libdir=3D/usr/pgsql-15/lib' '--with-lz4' '--enable-debug' '=
--enable-cassert' '--with-icu' '--with-llvm' '--with-perl' '--with-python' =
'--with-tcl' '--with-tclconfig=3D/usr/lib64' '--with-openssl' '--with-pam' =
'--with-gssapi' '--with-includes=3D/usr/include' '--with-libraries=3D/usr/l=
ib64' '--enable-nls' '--enable-dtrace' '--with-uuid=3De2fs' '--with-libxml'=
 '--with-libxslt' '--with-ldap' '--with-selinux' '--with-systemd' '--with-s=
ystem-tzdata=3D/usr/share/zoneinfo' '--sysconfdir=3D/etc/sysconfig/pgsql' '=
--docdir=3D/usr/pgsql-15/doc' '--htmldir=3D/usr/pgsql-15/doc/html' 'CFLAGS=
=3D-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=3D2 -fexceptions -fstack-protec=
tor-strong --param=3Dssp-buffer-size=3D4 -grecord-gcc-switches   -m64 -mtun=
e=3Dgeneric' 'LLVM_CONFIG=3D/usr/lib64/llvm5.0/bin/llvm-config' 'CLANG=3D/o=
pt/rh/llvm-toolset-7/root/usr/bin/clang' 'PKG_CONFIG_PATH=3D:/usr/lib64/pkg=
config:/usr/share/pkgconfig' 'PYTHON=3D/usr/bin/python3'

postgres=3D# SET wal_compression =3Dzstd;
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 >=3D 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=FCnd=FCz wrote:
> Hi,
>=20
> On Thu, 2022-05-19 at 11:16 -0500, Justin Pryzby wrote:
> >=20
> > Also, could you build v15 with --enable-zstd ?
>=20
> commit 1bd03ce822dea86438ae538bdbd39600359c0133
> Author: Devrim G=FCnd=FCz <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


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