Postgres 14 hot standby server server is running in Debian Linux under WSL. It saves wal log from master to pg_wal directory. wal_keep size is 100 GB.

Command

pg_recvlogical -P pgoutput -o proto_version=1 -o publication_names=koiktabelid_pub --create-slot --start --slot=naitategevust --dbname=postgres --file=tulem.log

writes modification commands to file

Command

pg_recvlogical --create-slot --start --slot=naitategevust --dbname=postgres --file=-

show modification commands in screen.

How to specify start time and number of commands to decode as pg_recvlogical parameters?

Its output format is too verbose, contains data types.

How show the next 100 SQL commands starting from from some date, e.g. from March 18, 2025 14:21:00 ?

If there is no ready solution, I can create ASP.NET Core 9 MVC controller for this. Controller should probably ask wal contents from server starting at this time using replication protocol or directly read wal files from pg_wal directory and decode them.

Replication sample in .html shows how to decode realtime replication messages for single table.

How to specify start time from which replication commands are returned? Or is there some existing wal decoder in C# or as command-line utility?

Plugin seems to convert wal to SQL. How to change it so it decodes wal log starting from given time?