How to create user for a db in postgresql?
I have installed postgresql 8.4 on my centos server and connected to root user from shell and accesing the postgresql shell.

i have created the database and user in postgresql.

Now I am trying to connect from my PHP script, but it shows me authentication failed.

So please tell me how to create new user and how to grant permissions to him for a particular DB?


How to create user for a db in postgresql?
===

I have installed postgresql 8.4 on my centos server and connected to root user from shell and accesing the postgresql shell.

i have created the database and user in postgresql.

Now I am trying to connect from my PHP script, but it shows me authentication failed.

So please tell me how to create new user and how to grant permissions to him for a particular DB?

