Re: Postgresql active-active nodes in cluster

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Postgresql active-active nodes in cluster
Дата
Msg-id CAKAnmm+ZXJ2TxhWSj9CJ_2MtaSxKqqT5kvEhqvb=X3s7g4KgTg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgresql active-active nodes in cluster  (Vidyashree H S <Shreevidya.hs@exaleapsemi.com>)
Список pgsql-general
Дерево обсуждения
On Mon, May 13, 2024 at 2:53 AM Vidyashree H S <Shreevidya.hs@exaleapsemi.com> wrote:
  • Is that multi master replication is not recommended to do ?

No, it is not recommended, as it has a very, very narrow use case, and comes with a lot of drawbacks. Sure, you COULD configure your car to also be able to ride across the river like a boat, but it's far easier to use a bridge, or a barge. And now your car is harder to care for, and has a lot more ways in which it could break.
  • If we can do, can I get any resource for implementing that on PostgreSQL which is open-source?
You still have not told us your use case. That can help us to guide you to the right solution. But for totally open source solutions there are not many out there. Here are some:


You can also in theory use logical replication if at least version 16:



Cheers,
Greg

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

Предыдущее
От: "Zwettler Markus (OIZ)"
Дата:
Сообщение: how to completely turn off statement error logging
Следующее
От: David Rowley
Дата:
Сообщение: Re: SELECT DISTINCT chooses parallel seqscan instead of indexscan on huge table with 1000 partitions