A PostgreSQL MCP server can remain available during failover and still return the wrong answer.
The connection retries against a replica.
The replica is behind.
A conversation combines a pre-failover result with a post-failover follow-up.
Every query succeeds, so the final answer looks complete.






