Stop a Postgres restart (or error) taking the whole app down

Addresses #1854.
The pg connection manager doesn't have a validte function ;)