Re: Methods to quiesce PostgreSQL DB without configuring log archival

Поиск
Список
Период
Сортировка
От Scott Mead
Тема Re: Methods to quiesce PostgreSQL DB without configuring log archival
Дата
Msg-id 01E4A593-0BBF-4A4E-817A-F542FA4074A0@openscg.com
обсуждение исходный текст
Ответ на Methods to quiesce PostgreSQL DB without configuring log archival  (MEERA <meeranair89@gmail.com>)
Ответы Re: Methods to quiesce PostgreSQL DB without configuring log archival
Список pgsql-general
Дерево обсуждения

On Nov 22, 2016, at 01:23, MEERA <meeranair89@gmail.com> wrote:

Hi all,

If archive_mode is not configured, and i use snapshot solution for backup of the server, how can i ensure data consistency? Is there a way to quiesce all the connections to DB?

If your snapshot solution is atomic, then you are *probably* okay. I would do a few restores to test, but atomic snapshots give you a point in time and should be consistent. 

Personally, I like archiving because it removes all of the maybes, but, that's me :)



Thanks,
Meera

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

Предыдущее
От: MEERA
Дата:
Сообщение: Methods to quiesce PostgreSQL DB without configuring log archival
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Partial update on an postgres upsert violates constraint