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