Re: Synchronous archiving

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: Synchronous archiving
Дата
Msg-id 54D040C3.2090507@BlueTreble.com
обсуждение исходный текст
Ответ на Synchronous archiving  (Laurence Rowe <l@lrowe.co.uk>)
Ответы Re: Synchronous archiving  (Michael Paquier <michael.paquier@gmail.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: Versioning Schema SQL ideas needed
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: partial "on-delete set null" constraint