Re:
| От | Pierre Ochsenbein |
|---|---|
| Тема | Re: |
| Дата | |
| Msg-id | CABG8FoM55JvZ+-wq8nMajJ3KBHx5cWos758EEAmEhWiYWMiO3g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: (Rui DeSousa <rui@crazybean.net>) |
| Ответы |
Re:
|
| Список | 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.
--
В списке pgsql-admin по дате отправления: