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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
