Restore functioning #active? for PostgreSQL

This reverts the substantive portion of 34c7e73.
Test checking #active? while a query is running

This is the behaviour that 34c7e73 was seeking to allow.
Synchronize all access to the underlying PG connection

It's not thread-safe, and we need to safely issue queries from both the
owning thread and the reaper.