Re:

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(at)crazybean(dot)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
pierreochsenbein(at)gmail(dot)com