test: add pgpool test environment

[matthewelwell]

Changes

The purpose of this PR is to create a test environment which uses pgpool as the database, with replication across 2 postgres nodes.

I have added a new workflow with a workflow_dispatch trigger, but temporarily I am using on: push to test the workflow in GH actions as well.

How did you test this code?

TODO