Add nicer error if the Postgres primary node has gone readonly

Add nicer error if the Postgres primary node has gone readonly #5657