Explicitly manage the provenance storage connection in journal client

Doing it implicitly makes pytest fixture teardown impossible because of
object references that are held for too long, preventing the postgresql
server from shutting down.