Need help in logical replication

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;

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@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;