Re: Need help in logical replication

[Divyansh Gupta JNsThMAudy <ag1567827@xxxxxxxxx>]

Thank you for the response Justin found and fixed the error

On Mon, 13 Jan 2025, 10:15 pm Justin, <zzzzz.graf@xxxxxxxxx> 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@xxxxxxxxx> 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!

CREATE PUBLICATION logical_replication_test

FOR TABLE dbo.logical_rep_test;

CREATE SUBSCRIPTION logical_replication_test_su

CONNECTION 'conn_strig'

PUBLICATION logical_replication_test;