Re:

Поиск
Список
Период
Сортировка
От Pierre Ochsenbein
Тема Re:
Дата
Msg-id CABG8FoM55JvZ+-wq8nMajJ3KBHx5cWos758EEAmEhWiYWMiO3g@mail.gmail.com
обсуждение исходный текст
Ответ на Re:  (Rui DeSousa <rui@crazybean.net>)
Ответы Re:  (Rui DeSousa <rui@crazybean.net>)
Список pgsql-admin
Дерево обсуждения
Thanks for you're feedback.
For sure I would like also to use streaming replication with synchronous commits. I would be more secure.. but on your stdby you have configure a script to become the primary automatically?

Le sam. 3 nov. 2018 à 17:45, Rui DeSousa <rui@crazybean.net> a écrit :
For an HA setup I would highly recommend using streaming replication with synchronous commits.  There is no reason to risk losing a single committed transaction in a HA setup.  As far as managing the system which I believe your question is more about; that is going to depend on your environment and there are numerous cluster solutions out there; personally I use a CARP based solution.

For DR it’s more customary to use asynchronous replication due to the high latency in most DR setups thus there is a risk of losing committed transactions.




--
Cordialement,

Pierre Ochsenbein
Mobile: +33668295394

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

Предыдущее
От: Rui DeSousa
Дата:
Сообщение: Re: How to revoke "Create Privilege" from a readonly user inpostgres?
Следующее
От: Rui DeSousa
Дата:
Сообщение: Re: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with theshutdown checkpoint