fix(postgres): improve non-blocking pool wait and refactor Postgres driver; add tests and infra updates

fix(postgres): improve non-blocking pool wait and refactor Postgres driver; add tests and infra updates #165