Re: Need help in logical replication

Thank you for the response Justin found and fixed the error

On Mon, 13 Jan 2025, 10:15 pm Justin, <zzzzz(dot)graf(at)gmail(dot)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 <
> ag1567827(at)gmail(dot)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;
>>
>>