Use pg_hba in postgresql::hba and allow all user to authentify with md5 ...

...on template1 database (required for /usr/local/sbin/pp-postgresql-user.sh)