Revision history of "Logical Replication"

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

  • curprev 17:19, 11 May 2022Ajay talk contribs 1,159 bytes +1,159 Created page with "=== On the host server === Modify postgresql.conf to be ready for logical replication wal_level=logical max_wal_senders=16 max_sync_workers_per_subscription=16 max_logical_replication_workers=20 Setup a replication user CREATE ROLE repl WITH NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN REPLICATION BYPASSRLS CONNECTION LIMIT -1 PASSWORD 'SOME SECURE PASSWORD'; Then, on all databases you want to sync, grant select per..." Tag: Visual edit