[ADMIN] WAL archiving to two locations in warm standby

2011-07-18 Thread Alanoly Andrews
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 /pgarcl

Re: [ADMIN] WAL archiving to two locations in warm standby

2011-07-18 Thread Raghavendra
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, Ju

Re: [ADMIN] WAL archiving to two locations in warm standby

2011-07-18 Thread Kevin Grittner
Alanoly Andrews wrote: > 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 > otherwis