Thank you for the response Justin found and fixed the error On Mon, 13 Jan 2025, 10:15 pm Justin, <zzzzz.g...@gmail.com> wrote:
> 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; >> >>
