When using pg_standby to remain in recovery mode on a warm standby system,
if there is a need to perform other actions in coordination with recovery
actions, the -x <auxiliary command> option implemented by this patch
enables that coordination. I considered adding the ability to override the
restoreCommand, however by keeping this separate and optional it is
possible to force retries of the auxiliary command until successful and
still utilize pg_usleep instead of looping within an external script or
command. And the previous behavior of pg_standby remains unchanged (other
than debug logging and documenting the option in usage) if the new option
is omitted.
I added this feature to help with synchronization of a content repository
consisting of a PostgreSQL db for meta-information and a separate file
store for content.
The auxiliary command enables forcing an rsync of the file store that is at
least as current as the found WAL segment file's db changes, and prevents
recovery of that WAL file unless the rsync can be performed successfully.
(See attached file: pg_standby.c.diff)
Please consider incorporating this feature.
Chris
_____________________________________________
Christopher K. Johnson
Director of IT
DeskNet Inc.
RHCE# 804005699817957
"A society grows great when old men plant trees whose shade they know they
shall never sit in" - Greek Proverb