Skip site navigation (1) Skip section navigation (2)

Re: WAL archiving to two locations in warm standby

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Alanoly Andrews" <alanolya(at)invera(dot)com>, "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: WAL archiving to two locations in warm standby
Date: 2011-07-18 13:49:54
Message-ID: 4E23F3B2020000250003F441@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
Alanoly Andrews <alanolya(at)invera(dot)com> 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
> otherwise?
 
archive_command can call a script, which can be arbitrarily complex,
so sure -- you can do whatever you want within it.  That said, why
not copy the archive to the local directory, and then have an rsync
process on the other machine (going through a remote daemon) try to
pull new files over once per minute?  That works well for us.
 
-Kevin

In response to

pgsql-admin by date

Next:From: Kyle R. BurtonDate: 2011-07-19 15:57:09
Subject: 9.0 Replication and archive cleanup
Previous:From: RaghavendraDate: 2011-07-18 13:42:16
Subject: Re: WAL archiving to two locations in warm standby

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group