Support for auth method "md5" as well as "trust" to make Foreign Data Wrappers work in tests

[davidboden]

In a test environment that uses Foreign Data Wrapper (FDW) connections between two databases, this error is generated when attempting to access the foreign tables:

Caused by: org.postgresql.util.PSQLException: ERROR: password is required
  Detail: Non-superuser cannot connect if the server does not request a password.
  Hint: Target server's authentication method must be changed.

This can be fixed by changing the authentication method to "md5". At the moment, "trust" is hardcoded into EmbeddedPostgres as the authentication method.

[davidboden]

PR incoming...

[mikebell90]

We released 1.0.0 which is a major rewrite. If you'd like to submit a PR to 1.0.0 (master) , we'd certainly look at it. Because yeah right now it's still "trust"