Re: WAL archiving to two locations in warm standby

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(at)invera(dot)com>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(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 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 <http://abaca.com/customers.html>
> ------------------------------
>
>