A J <s5aly@yahoo.com> writes:
> Couple of questions: 1. At what frequency is the
> archive_cleanup_command executed from the recovery.conf file on the
> standby ?
Typically once per WAL file being processed.
> 2. If for some reason lets say a WAL file is missing from the
> archive directory but the files after that are present. When the
> standby tries to restore the missing WAL file, does it fail or it
> simply skips the missing WAL file and goes to the next one.
Neither.
A standby will sit waiting forever for the next WAL segment that it
needs.
You can't just skip missing WALs :-)
HTH
> Thanks.
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 305.321.1144