Re: Is it possible to add support for PostgreSQL-15 and newer versions in omnipitr?

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: "hailong(dot)li" <hailong(dot)li(at)qunar(dot)com>
Cc: depesz(at)depesz(dot)com, "xuzhao(dot)zhao" <xuzhao(dot)zhao(at)qunar(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Is it possible to add support for PostgreSQL-15 and newer versions in omnipitr?
Date: 2023-12-13 13:33:59
Message-ID: ZXmyx/e2OWAKlT3S@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Greetings,

* hailong.li (hailong(dot)li(at)qunar(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2023-12-13 14:13:20 Re: BUG #18241: PushTransaction may cause Standby to execute ItemIdMarkDead
Previous Message PG Bug reporting form 2023-12-13 09:00:01 BUG #18246: pgstathashindex() attempts to read invalid file for hash index attached to partitioned table