Re: Single mater replica setup for an existing DB

Поиск
Список
Период
Сортировка
От Vijaykumar Jain
Тема Re: Single mater replica setup for an existing DB
Дата
Msg-id CAM+6J97jdwwnLeExMV4Uare7r5EfjfGCXKhzahTfMq-m81p8BA@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
Дерево обсуждения

On Mon, 16 Aug 2021 at 00:47, Digimer <lists@alteeve.ca> wrote:

Hi all,

  Could I get recommendations on how to convert an existing database to a single-master replica setup?

  I'm running on RHEL 8 (pgsql version 10.17). I'd like to replicate the existing database to 1 (maybe 2) other hosts, synchronously ideally though async might be OK.


hands on using katakoda:

blogs:
There are many blogs for versions 11, 12 also. 

-- i moved from manual to patroni, so found patroni simple to set up. ymmv
postgres HA using patroni.
There is an option to add an existing node to the patroni cluster. 

official reference (especially for tuning config):

--
Thanks,
Vijay
Mumbai, India

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Cluster fencing tool/software for PostgreSQL cluster with streaming replication
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Using a TRIGGER with window functions.