WAL archiving to two locations in warm standby

From: Alanoly Andrews <alanolya(at)invera(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: WAL archiving to two locations in warm standby
Date: 2011-07-18 13:16:07
Message-ID: 09B23E7BF70425478C1330D893A722C604FE4E3A90@MailSVR.invera.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I have a Warm Standby set up on two machines (running AIX and Korn shell) in a Postgres 8.4.7 environment. The "archive_command" is set to copy a completed WAL archive to two locations, one on the primary and the other on the Standby machine. Thus:
archive_command = '/bin/cp %p /pgarclog/l01/%f; rcp /pgdata01/pg_xlog/%f mach2:/pgarclog/l01/%f '

As each WAL completes, it is copied over to the primary location and also remote-copied over to the standby machine("mach2" above). This works quite fine. The problem is that if the standby machine is down for some reason or the network is down, the archive command keeps re-trying the command. If the standby machine is unreachable for a long period, this is undesirable. What I would like to tell the postgres engine on the primary is to be "satisfied" if the archiving to the primary location succeeded and to NOT re-try if the failure was in the remote copy.

Is there a way to achive this through the "archive_command" or otherwise?

Thanks.

Alanoly Andrews (alanolya(at)invera(dot)com)

****************************************************
This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

Ce courriel est confidentiel et protg. L'expditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) dsign(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser immdiatement, par retour de courriel ou par un autre moyen.
****************************************************

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Raghavendra 2011-07-18 13:42:16 Re: WAL archiving to two locations in warm standby
Previous Message Ken Caruso 2011-07-17 16:54:13 Re: 9.0.4 Data corruption issue