| From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
|---|---|
| To: | Laurence Rowe <l(at)lrowe(dot)co(dot)uk>, PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Synchronous archiving |
| Date: | 2015-02-03 03:30:11 |
| Message-ID: | 54D040C3.2090507@BlueTreble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2015-02-03 03:44:28 | Re: partial "on-delete set null" constraint |
| Previous Message | Jim Nasby | 2015-02-03 03:27:46 | Re: Versioning Schema SQL ideas needed |