title: Cant login with postgresql user created via ansible
body: <p>Normally, I would create create postgresql user like this.</p>
  
  <pre><code>sudo -u postgres psql
  create user deploy_sample with password 'secret';
  create database deploy_sample_production owner deploy_sample;
  </code></pre>
  
  <p>I tried to create the user through ansible script with this task</p>
  
  <pre><code>  - name: Create database user
      become: yes
      become_user: postgres
      postgresql_user: 
        user: user123 
        password: password123
        encrypted: yes
        state: present
  </code></pre>
  
  <p>This does create a user but i cant login using the creds.</p>
  
  <p>I tried to login with this command <code>psql --username=user123 --password</code>. I get <code>peer authenticate failuer</code> error.</p>