title: How to create user for a db in postgresql?
body: <p>I have installed PostgreSQL 8.4 on my CentOS server and connected to root user from shell and accessing the PostgreSQL shell.</p>
  
  <p>I created the database and user in PostgreSQL.</p>
  
  <p>While trying to connect from my PHP script it shows me authentication failed.</p>
  
  <p>How do I create a new user and how to grant permissions to them for a particular DB?</p>