Thread

1. Need help in logical replication

   Divyansh Gupta JNsThMAudy <ag1567827@gmail.com> — 2025-01-13T12:29:52Z

   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;
   

2. Re: Need help in logical replication

   Rob Sargent <robjsargent@gmail.com> — 2025-01-13T15:38:17Z

   
   
   > On Jan 13, 2025, at 5: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!
   > 
   > 
   
   Maybe you could send your ddl in plain text?
   
   > 
   

3. Re: Need help in logical replication

   Justin <zzzzz.graf@gmail.com> — 2025-01-13T16:45:25Z

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

4. Re: Need help in logical replication

   Divyansh Gupta JNsThMAudy <ag1567827@gmail.com> — 2025-01-13T17:19:41Z

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