From: Stephen Frost <sfrost@snowman.net>
To: hailong.li <hailong.li@qunar.com>
Cc: depesz@depesz.com, "xuzhao.zhao" <xuzhao.zhao@qunar.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Is it possible to add support for PostgreSQL-15 and newer versions in omnipitr?
Date: Wed, 13 Dec 2023 08:33:59 -0500
Message-ID: <ZXmyx/e2OWAKlT3S@tamriel.snowman.net> (raw)
In-Reply-To: <8b807ace-32a0-4406-8a5e-267598107aa8@qunar.com>
References: <04c32c47-d952-4da2-b274-b5a5ace2f007@qunar.com>
<ZW84SzJV2slhlNeZ@depesz.com>
<8b807ace-32a0-4406-8a5e-267598107aa8@qunar.com>
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，but
> our blocksize is 32k.😭
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
Attachments:
signature.asc (application/pgp-signature, 832B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: sfrost@snowman.net, hailong.li@qunar.com, 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?
In-Reply-To: <ZXmyx/e2OWAKlT3S@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox