Hi Divyansh, Go to the subscriber and look for errors in the PostgreSQL logs.
When creating a subscription the default action is to sync the tables. Is the subscriber table empty?? Thank you, On Mon, Jan 13, 2025 at 7:30 AM Divyansh Gupta JNsThMAudy < ag1567...@gmail.com> wrote: > Hii PostgreSQL Community, > > I am setting up logical replication between two clusters in the same > subnet group. I’ve created a publication on the primary and a subscription > on the secondary, and the replication slot has been created. However, the > slot remains inactive, and changes aren’t being applied on the subscriber. > > I am using AWS RDS for that > > Could you please help me identify the possible cause and resolution for > this issue? > > Thank you in advance! > > [image: image.png] > [image: image.png] > > CREATE PUBLICATION logical_replication_test > > FOR TABLE dbo.logical_rep_test; > > CREATE SUBSCRIPTION logical_replication_test_su > > CONNECTION 'conn_strig' > > PUBLICATION logical_replication_test; > >
