Re: Frequency of archive_cleanup_command

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