Re: Question about Logical Replication - Mailing list pgsql-novice

From Efraín Déctor
Subject Re: Question about Logical Replication
Date
Msg-id 8d81155a-3e78-055a-660e-655e642c322c@motumweb.com
Whole thread Raw
In response to Re: Question about Logical Replication  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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 by date:

Previous
From: Marco Tosato
Date:
Subject: Efficient way for storing lists in PostgreSQL
Next
From: Stephen Froehlich
Date:
Subject: How to session_preload_libraries multiple libraries inpostgresql.conf