PostgreSQL - Advanced Features
After creating a subscription, no data appears on the subscriber. Which of the following is a common reason for this issue?
After creating a subscription, no data appears on the subscriber. Which of the following is a common reason for this issue?
medium📝 Debug Q6 of 15
Step-by-Step Solution
Solution:
Step 1: Identify replication setup
Data replicates only for tables included in the publication.Step 2: Analyze options
The publication does not include the tables intended for replication. is correct because if the publication excludes tables, no data replicates. The subscriber database is running a different PostgreSQL major version. is unlikely as minor version differences are tolerated. The subscriber has insufficient disk space for replication slots. is incorrect; disk space affects replication slots but usually causes errors, not silent no data. The subscription was created with the wrong user password. would cause connection failure, not silent no data.Final Answer:
The publication does not include the tables intended for replication. -> Option DQuick Check:
Publication must include tables to replicate data [OK]
Quick Trick: Check publication includes tables to replicate data [OK]
Common Mistakes:
- Assuming subscription creation alone replicates all tables
- Ignoring publication table list
- Confusing connection errors with no data replication
Master "Advanced Features" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes