NCP-DB-6.10 · Question #116
While restoring a PostgreSQL HA instance, an administrator notices that the restore of a standby node has failed. The primary node is ready to seive application traffic. In what state does NDB leave…
The correct answer is C. ONLINE. When restoring a PostgreSQL HA instance in NDB, if the standby node fails to restore but the primary node is successfully restored and ready to serve application traffic, NDB considers the database operational from the perspective of the primary node. In this scenario, NDB…
Question
While restoring a PostgreSQL HA instance, an administrator notices that the restore of a standby node has failed. The primary node is ready to seive application traffic. In what state does NDB leave the database?
Options
- APAKFIAL.READY
- BOFFLINE
- CONLINE
- DRECOVERY PENDING
How the community answered
(39 responses)- A3% (1)
- B8% (3)
- C79% (31)
- D10% (4)
Explanation
When restoring a PostgreSQL HA instance in NDB, if the standby node fails to restore but the primary node is successfully restored and ready to serve application traffic, NDB considers the database operational from the perspective of the primary node. In this scenario, NDB leaves the database in an "ONLINE" state, reflecting that the primary node is functional and capable of handling requests, even though the HA configuration is not fully intact due to the standby failure. The administrator would need to address the standby node separately (e.g., by re-provisioning or troubleshooting), but the database's state is determined by the primary node's readiness.
Topics
Community Discussion
No community discussion yet for this question.