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