Date: Wed, 13 Dec 2023 08:33:59 -0500
From: Stephen Frost <sfrost@snowman.net>
To: "hailong.li" <hailong.li@qunar.com>
Cc: depesz@depesz.com, "xuzhao.zhao" <xuzhao.zhao@qunar.com>,
	pgsql-bugs@lists.postgresql.org
Subject: Re: Is it possible to add support for PostgreSQL-15 and newer
 versions in omnipitr?
Message-ID: <ZXmyx/e2OWAKlT3S@tamriel.snowman.net>
References: <04c32c47-d952-4da2-b274-b5a5ace2f007@qunar.com>
 <ZW84SzJV2slhlNeZ@depesz.com>
 <8b807ace-32a0-4406-8a5e-267598107aa8@qunar.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="mi5UskQYJhOaqxnk"
Content-Disposition: inline
In-Reply-To: <8b807ace-32a0-4406-8a5e-267598107aa8@qunar.com>
User-Agent: Mutt/2.1.4 (2021-12-11)
Archived-At: 
 <https://www.postgresql.org/message-id/ZXmyx/e2OWAKlT3S%40tamriel.snowman.net>
Precedence: bulk


--mi5UskQYJhOaqxnk
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Greetings,

* hailong.li (hailong.li@qunar.com) wrote:
> OmniPITR is an very excellent software!

Unfortunately, it's not been maintained in many many years and used
deprecated and now removed interfaces because those interfaces resulted
in cases where PG wouldn't properly restart from a crash when it should
and encouraged users to do things which could lead very easily to
corruption.

> Btw, pgbackrest only supports the default 8k blocksize of PG instances=EF=
=BC=8Cbut
> our blocksize is 32k.=F0=9F=98=AD

There's been some work towards adding support for alternative block size
PG instances in pgbackrest.  The open pull request is here:

https://github.com/pgbackrest/pgbackrest/pull/2197

If you're interested in this then I strongly encourage you to take a
look at that pull request and try out pgbackrest with it and provide
your feedback on it.

Independently, it'd be very interesting to hear about your use case and
why you're running with 32K block sizes instead of the default 8K.
There's been some work to make PostgreSQL able to run with different
block sizes which are chosen at initdb-time (instead of having it be a
compile-time option), presumably that would also be interesting for your
use-case...?

Thanks,

Stephen

--mi5UskQYJhOaqxnk
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEwf6gbxKhD863zrx/7WyKOINHZFUFAmV5ssQACgkQ7WyKOINH
ZFXxPA//S97FkKAgWiPGPfsvCQGb83QlTQf9sazgrkip8syH2/ijyvR/ePu5rKBV
DgbfOtAgQhe3BWAJeRF3VLz0RtT3mq5BrZK4/Lfvane3xD4tjWEvC+FWMkfEjCvM
vE6ULrTag4AMcrnwq+shbywNmbnmEznQPCz6tdu4BqYX1scb6CCMBzVOsv5MvIZt
L5Vmg4Vlc9GYzUjFk3pVYvL2lSv27gyLMqf0ryLUdpmy9kkq+0pBL/R4wD82oDRs
lOTGT0DZoDOKTQC+E23/mQ29DzXkRPeh+4g87owc76elXRL+Y0WDMW5dPKOYpad5
2l+fvE44Bw8B5tTXzqy2tpUrQCDDgZfNKQSmYzdmgYOmXlIoQ0w/oXGAsz6iO6jz
T8rSDqZObA3+4AqCCZEE8PhUAG9iTm+4FW21H62ikNBOamg9Bt9ZUko1cbNB6+PW
FH4scSRfOwD0H1cVHfXg1q8K/ZT6g3q6cpeiOwvq8cX2VsxX+hvBoWztq8/IDEdh
7vxrkj8OUKG8O4Lc+ffbGMmlogoSpNMOKogj+lrEUuDgHCvuQ43guAmTh31K7avs
qKVzqvEa9QBDahC83qrFJdlZVus2xBdRh+7YUcszRIvk0QiD5I/r0kQ4BE8HsXDF
4g88t1Rh0WSsmx6RShGDz027Da/zedU/WMfVMOCbd+5zX9vl+BQ=
=Hb+H
-----END PGP SIGNATURE-----

--mi5UskQYJhOaqxnk--