Thread: Two postgres masters
Hi
Is it possible to have two masters in an environment?
regards
On Thu, Nov 12, 2020 at 8:51 AM Yambu <hyambu@gmail.com> wrote:
Is it possible to have two masters in an environment?
Do you mean multi-master replication?
Regards,
Juan José Santamaría Flecha
Yes multi-master
On Thu, Nov 12, 2020 at 1:05 PM Juan José Santamaría Flecha <juanjo.santamaria@gmail.com> wrote:
On Thu, Nov 12, 2020 at 8:51 AM Yambu <hyambu@gmail.com> wrote:Is it possible to have two masters in an environment?Do you mean multi-master replication?Regards,Juan José Santamaría Flecha
But be willing to throw away your ACID compliancy when you go to mulit-master mode. Why? There is no global lock manager across active instances. PostgreSQL is basically active-passive except for some variations like Postgres XL, etc.
Regards,
Michael Vitale
Yambu wrote on 11/12/2020 7:15 AM:
Regards,
Michael Vitale
Yambu wrote on 11/12/2020 7:15 AM:
Yes multi-masterOn Thu, Nov 12, 2020 at 1:05 PM Juan José Santamaría Flecha <juanjo.santamaria@gmail.com> wrote:On Thu, Nov 12, 2020 at 8:51 AM Yambu <hyambu@gmail.com> wrote:Is it possible to have two masters in an environment?Do you mean multi-master replication?Regards,Juan José Santamaría Flecha