pgreplay VS Logidze

pgreplay parses not the WAL Write Ahead Log but the log file: https://github.com/laurenz/pgreplay

From "A PostgreSQL Docker container that automatically upgrades your database" (2023) https://news.ycombinator.com/item?id=36748041 :

pgkit wraps Postgres PITR backup and recovery:

This blog was just to verify that it works with YugabyteDB. Check pgreplay documentation for more, all works the same in YugabyteDB. If you want to capture a workload from connections on multiple database nodes, each one will have their logfile. You can merge them. The Session ID (the 6th field in the csvlog built from start time and backend pid will probably not collide with another one, but you can make it unique by concatenating a node number if you want). The replay connects to one node, but though a HA proxy the connections can be distributed to multiple ones. All depends on what you want to capture and wh you want to replay. Capturing from PostgreSQL and replaying to YugabyteDB is also a good way to check that all works the same without performance regressions.

There's an interesting approach to it that works with Rails and PostgreSQL using triggers.

https://github.com/palkan/logidze

https://github.com/palkan/logidze is my favorite for these kind of things

Have you considered https://github.com/palkan/logidze ?

Something like this might be an option? https://github.com/palkan/logidze