Обсуждение: Two postgres masters

Поиск
Список
Период
Сортировка

Two postgres masters

От
Yambu
Дата:
Hi

Is it possible to have two masters in an environment?

regards

Re: Two postgres masters

От
Juan José Santamaría Flecha
Дата:

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 

Re: Two postgres masters

От
Yambu
Дата:
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 

Re: Two postgres masters

От
MichaelDBA
Дата:
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:
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