title: Postgresql Authentication method issue
body: <p>i wonder why postgres allows trust Authentication method as it allow any role to connect without providing a password!!</p>
  
  <p>if any role change the pg_hba.conf to trust then the server will be unsecure and will open to any role with any password </p>
  
  <p>i would like to prevent any connection to the server without providing the right password , so how can we prevent this ? 
   is their any best practices follow in order to secure postgres server ?</p>