Re: Multi-master replication - Mailing list pgsql-general

From Laura Smith
Subject Re: Multi-master replication
Date
Msg-id u13RKkbT2qJqho2kimhLGIBjXWYF8ztHM3XzRCjQh4j5QNlHNp8awT6HzBF7nK2K0L9nMid0kcIYsAUSZ-9a4s1gJOt6vNn4aSpyH540Vf0=@protonmail.ch
Whole thread Raw
In response to Multi-master replication  (Zahir Lalani <ZahirLalani@oliver.agency>)
Responses RE: Multi-master replication  (Zahir Lalani <ZahirLalani@oliver.agency>)
List pgsql-general
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐

On Friday, August 13th, 2021 at 9:00 AM, Zahir Lalani <ZahirLalani@oliver.agency> wrote:

> Confidential
>
> Hello all
>
> Does anyone on the list have production experience of using PG in a multi-master setup – if so using which tools?
>
> Thx
>
> Zahir



I have sometimes considered it, but it always struck me that given there is no first-class support for it, multi-master
inpostgres is just an opportunity for so many foot-guns to enable to things to go terribly, terribly wrong. 

Maybe you need to look at something like CockroachDB which has a degree of Postgres syntax compatability
(https://www.cockroachlabs.com/blog/why-postgres/).  N.B. Not speaking from experience here, CockroachDB is something
I'vewanted to play with for a long time but never had the time ! 





pgsql-general by date:

Previous
From: Vijaykumar Jain
Date:
Subject: Re: Partitioning a table by integer value (preferably in place)
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Getting pg_stat_database data takes significant time