Re: WAL archiving to two locations in warm standby

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

 



In PostgreSQL, instance cannot recognize the network failure, however, I think you can do with OS scripting and calling in "archive_command".
Eg:-
archive command = '/home/scripts/arch_copy.sh %p %f'

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/



On Mon, Jul 18, 2011 at 6:46 PM, Alanoly Andrews <alanolya@xxxxxxxxxx> wrote:

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@xxxxxxxxxx)



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 protégé. L'expéditeur 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) désigné(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser immédiatement, par retour de courriel ou par un autre moyen.

Mail sent via the Abaca EPG




[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