Make the storage test fixture connect to postgres itself

This avoids reusing a potentially stale connection handle. Also allows testing potential connection pooling behavior.

This forces us to do proper cursor sanitation as well, a bunch of "transactional" operations weren't actually transactional.

Test Plan

another round of make test still working

---

Migrated from D323 (view on Phabricator)