0

I am testing replication from Citus(Cloud Hosted) to my RDS Aurora Postgres with ref https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Replication.Logical.html#AuroraPostgreSQL.Replication.Logical.Configure

Everything ran successful but on subscribers, no data is coming so what may be wrong? how do I troubleshoot

SELECT count(*) FROM LogicalReplicationTest;

Note: on Citus DB I can See Publication: enter image description here

But in my RDS can't see Subscriptions in the list in spite of CREATE SUBSCRIPTION testsub CONNECTION was successful: enter image description here

I observed that when I run SELECT count(*) FROM LogicalReplicationTest; there is no data but only column name showing Lock symbol as shown in this screenshot! any idea what this lock symbol means apart from the Read-only Column? why it's not listing data inside that table which is in publisher DB Is there any permission I have to delegate to the table when creating a publication?

enter image description here

Ashish Karpe
  • 5,087
  • 7
  • 41
  • 66
  • What does "on citus" mean? Your self-hosted PostgreSQL with that extension installed? Citus cloud? – jjanes Oct 11 '21 at 15:15
  • What versions of everything? What is in the error log on the Aurora? Rather than giving us screenshots from PgAdmin, show us text from psql. Debugging one thing at a time is already enough work, you don't need to debug PgAdmin simultaneously as well. – jjanes Oct 11 '21 at 15:20
  • @jjanes we are using Citus cloud service – Ashish Karpe Oct 12 '21 at 04:26
  • @jjanes Actually there were no errors while creating subscriptions ie CREATE SUBSCRIPTION Query returned successfully in 2 min 13 secs. so subscription is created successfully with no errors but when check table don't see injected data in replica side so I want to know how to troubleshoot this issue – Ashish Karpe Oct 12 '21 at 04:47
  • also when I ran SELECT count(*) FROM LogicalReplicationTest; there is no error in RDS logs but the table content are blank .....I have updated this in my question – Ashish Karpe Oct 12 '21 at 05:12
  • Version for RDS aurora-postgresql13 and that of Postgres hosted in Citus DB is lesser or not the same so can that be the reason for not showing replication table data or subscriptions? – Ashish Karpe Oct 12 '21 at 05:35
  • My Citus DB Postgres version is 9.51 – Ashish Karpe Oct 12 '21 at 05:50
  • @jjanes Ohh my mistake Citus DB Postgres Version is 13.2 and Citus Version is 9.5-1 and Version for RDS aurora-postgresql13. So this seems may not be a version issue. – Ashish Karpe Oct 12 '21 at 07:20

0 Answers0