Re: Synchronous archiving

On 1/27/15 1:51 AM, Laurence Rowe wrote:
> I have a relatively small database with not many writes. However, I'm
> keen to ensure that those writes I receive are not lost. Archiving gets
> me most of the way there, but it is asynchronous. Is there any way to
> archive individual WAL records without running a replica?
>
> Running in Amazon's cloud, I imagine a synchronous counterpart to WAL-E
> that backed up the individual WAL records to one of their reliable but
> less featureful systems.

The only reasonable way to do this that I'm aware of is to setup
synchronous replication:
http://www.postgresql.org/docs/devel/static/warm-standby.html#SYNCHRONOUS-REPLICATION
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com