On Thu, Jun 3, 2010 at 2:14 AM, Kevin Grittner <kevin.gritt...@wicourts.gov>wrote:
> Manohar Bhattarai <manoharbhatta...@gmail.com> wrote: > > > FATAL: password authentication failed for user "postgres" > > > But the password is the same that i use to login postgres user in > > the terminal. > > What could be the problem? > > When you say "postgres user in the terminal", do you mean logging in > to the operating system? If so, that has nothing to do with the > database login unless you choose to make it so by having an "ident" > entry in the pg_hba.conf file. > > http://www.postgresql.org/docs/8.3/interactive/client-authentication.html > > > I am not able to understand how to start creating a new user > > and a new database after a fresh installation of postgres. > > Once you get logged in with the postgres user, that would be the > CREATE DATABASE and CREATE USER statements: > > http://www.postgresql.org/docs/8.3/interactive/sql-createdatabase.html > > http://www.postgresql.org/docs/8.3/interactive/sql-createuser.html > > -Kevin > Thank you. The problem is solved. :) Thanks for your help. -- Regards, Manohar Bhattarai (मनोहर भट्टराई) Blogs: http://manoharbhattarai.wordpress.com/ http://manoharbhattarai.posterous.com/ http://manoharbhattarai.blogspot.com/ Microblogs: Twitter :- http://twitter.com/manoharmailme Identi.ca :- http://identi.ca/manoharbhattarai