Archive clean up command in recovery.conf

From: Prince Pathria <prince(dot)pathria(at)goevive(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Archive clean up command in recovery.conf
Date: 2018-09-23 12:13:34
Message-ID: CAON0Day9vqmy3HSqB2eskSN-uxUuQpW+eCvdH1rRt+YO=39sfg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I have a doubt, assume that I have 3 psql10 nodes (n1, n2, n3) and n1 is
master ,n2+n3 are standbys. In n1 archive mode is on, and wal_logs are
going to volume which is shared with n2 and n3. If
archive_cleanup_command = 'pg_archivecleanup /path/to/nfs %r' is enabled
on both n2 and n3.

Can a situation might arise that a wal segment required by n2 is already
cleaned up by n3?

If yes, then how to mitigate it?

Thanks!

Prince Pathria Systems Architect Evive +91 9478670472 goevive.com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Aldo Sarmiento 2018-09-23 15:53:26 New replica with pgbackrest
Previous Message Prince Pathria 2018-09-21 21:11:56 WAL segments held for replcation