On Thu, Jun 3, 2010 at 2:14 AM, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote:
Manohar Bhattarai <manoharbhattarai@xxxxxxxxx> wrote:
> FATAL: password authentication failed for user "postgres"
> But the password is the same that i use to login postgres user inWhen you say "postgres user in the terminal", do you mean logging in
> the terminal.
> What could be the problem?
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
Once you get logged in with the postgres user, that would be the
> I am not able to understand how to start creating a new user
> and a new database after a fresh installation of postgres.
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
