Re: Frequency of archive_cleanup_command

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



A J <s5aly@xxxxxxxxx> 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@xxxxxxxxxxx
p: 305.321.1144

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux