title: How to provide a password for PostgreSQL's createdb non-interactively?
body: <p>I have a task in phing where before tests I drop the database if exists and create it. This is run on Jenkins. 
  I want to do it with createdb like this:</p>
  
  <pre><code>&lt;exec command="createdb my_database" /&gt;
  </code></pre>
  
  <p>The thing is that the createdb is asking me to authenticate and adding -Umy_user parameter is not a problem - the issue is that I cannot specify a password in the createdb command. And I don't want to create a role for the system user ("jenkins" in this case). Is there a solution for that ? </p>