Search Postgresql Archives

Re: [ADMIN] Exception while accessing database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux