Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
29.8. Configuration Settings
Prev UpChapter 29. Logical ReplicationHome Next

29.8. Configuration Settings

Logical replication requires several configuration options to be set.

On the publisher side,wal_level must be set tological, andmax_replication_slots must be set to at least the number of subscriptions expected to connect, plus some reserve for table synchronization. Andmax_wal_senders should be set to at least the same asmax_replication_slots plus the number of physical replicas that are connected at the same time.

The subscriber also requires themax_replication_slots be set to configure how many replication origins can be tracked. In this case it should be set to at least the number of subscriptions that will be added to the subscriber.max_logical_replication_workers must be set to at least the number of subscriptions, again plus some reserve for the table synchronization. Additionally themax_worker_processes may need to be adjusted to accommodate for replication workers, at least (max_logical_replication_workers +1). Note that some extensions and parallel queries also take worker slots frommax_worker_processes.


Prev Up Next
29.7. Security Home 29.9. Quick Setup
pdfepub
Go to Postgres Pro Standard 13
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp