QuestionQ48Verified/Monitoring and AuditingCopy linkReport a problemAsk AstroTutorSave questionRefer to the exhibit. How can you verify that the Follower has a current copy of the database?ACompare the pgcurrentxlog_location from the Leader to the Follower you need to validate against.BCount the number of components in pgstartreplication and compare this to the total number of Followers in the deployment.CValidate that the Follower container ID matches the node in the info endpoint on the Leader.DRetrieve the credential from a test application on the Leader cluster; then retrieve against the Follower and compare if they are accurate.Show AnswerAnswerExplanationA PostgreSQL follower’s currency is determined by its WAL/XLOG position. Comparing the Leader’s current XLOG location with the Follower’s reported location confirms whether the Follower has received the same database changes and is current.Learn morePostgreSQL Documentation — Log-Shipping Standby ServersShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion