Re: Allow logical replication in the same cluster

2025-09-07 Thread Chao Li
Hi Amit, Thanks for your info. > On Sep 6, 2025, at 12:32, Amit Kapila wrote: > > You can avoid this problem by creating a slot first on publisher with > something like: > postgres=# select pg_create_logical_replication_slot('s1', 'pgoutput', > false, true); > pg_create_logical_replication_slot

Re: Allow logical replication in the same cluster

2025-09-05 Thread Amit Kapila
On Fri, Sep 5, 2025 at 8:21 AM Chao Li wrote: > > I was doing some test about logical replication a few days ago. When I tried > to setup a logical replication on my Macbook. > > The basic workflow is simple: > > ``` > Step 1: edit postgresql.conf and set: > > wal_level = logical > max_replicatio

Allow logical replication in the same cluster

2025-09-04 Thread Chao Li
Hi Hacker, I was doing some test about logical replication a few days ago. When I tried to setup a logical replication on my Macbook. The basic workflow is simple: ``` Step 1: edit postgresql.conf and set: wal_level = logical max_replication_slots = 4 max_wal_senders = 4 Step 2: create two dat