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.