Thread: Add arbitrary xid and mxid to pg_resetwal

Add arbitrary xid and mxid to pg_resetwal

From
Daniil Davydov
Date:
Hi,
I prepared a patch that will allow us to set arbitrary values in -m and -x options for pg_resetwal. For now, it is not possible to specify a value that does not fit into existing SLRU segments, and 
main idea of this patch (for REL_17_STABLE) is to create such segments inside pg_resetwal's main() function.
In my opinion, this will be useful primarily to simplify testing, since at the moment you have to create segments manually (as in this article).

Patch also contains additional tests for pg_resetwal (regression is called to make sure that all postgres components are working correctly, but maybe it can be replaced with something more "compact").

What do you think about the idea of adding such functionality?

--
Best regards,
Daniil Davydov

Attachment