Run unit tests against dummy database during Github Actions builds

This will involve updating the `.github/workflows/*.yml` files to actually install postgresql-server, configure a dummy database, setup user credentials, and then run the `make test` target.