Re: Allow logical replication in the same cluster

2025-09-17 Thread Amit Kapila
On Mon, Sep 8, 2025 at 8:20 AM Chao Li wrote: > > 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'

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