Switch to using peer authentication in dev and test for Postgres

This accompanies the puppet changes in CI and development:

- https://github.com/alphagov/ci-puppet/pull/200
- https://github.gds/gds/puppet/pull/2008