Re: Question about Logical Replication

Поиск
Список
Период
Сортировка
От Efraín Déctor
Тема Re: Question about Logical Replication
Дата
Msg-id 8d81155a-3e78-055a-660e-655e642c322c@motumweb.com
обсуждение исходный текст
Ответ на Re: Question about Logical Replication  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-novice

Thank you David.

So the defaults are fine for me since I will only have 1 subscriber.

Thanks again!

El 11/12/2017 a las 01:42 p. m., David G. Johnston escribió:
On Mon, Dec 11, 2017 at 12:26 PM, Efraín Déctor <efraindector@motumweb.com> wrote:
Hello.

Do I need to configure the settings (max_replication_slots , max_wal_senders, etc) according to the number of tables to be replicated?

​In short, no.  The determination of values for these settings is based upon other aspects of the overall multi-server system.​

Physical replication is cluster-based, not table based.  The slots/senders are roughly the number of servers involved in the setup.

Logical replication is publication based.

"A publication is a set of changes generated from a table or a group of tables, and might also be described as a change set or replication set. Each publication exists in only one database."

The slots/senders are consumed as servers subscribe to publications.

David J.


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

Предыдущее
От: Marco Tosato
Дата:
Сообщение: Efficient way for storing lists in PostgreSQL
Следующее
От: Stephen Froehlich
Дата:
Сообщение: How to session_preload_libraries multiple libraries inpostgresql.conf