Обсуждение: Exception while accessing database

Manohar Bhattarai <manoharbhattarai@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

Manohar Bhattarai wrote:
> Hi,
> This problem was initially asked to pgsql-jdbc@postgresql.org
> <mailto:pgsql-jdbc@postgresql.org> and I was suggested to ask this
> problem here.
> So my initial problem was that i was not able to set the Driver for
> postgresql. I solved that problem with the help there.
>
> But I have a new exception and it is :
> org.postgresql.util.PSQLException: FATAL: password authentication
> failed for user "postgres"
>
> I am giving the line for connection that i am using :
> connection = DriverManager.getConnection(connectionURL, "postgres",
> "mypasswordhere");
>
> But the password is the same that i use to login postgres user in the
> terminal.
> What could be the problem?
>

from the psql command line tool,  ALTER USER username WITH PASSWORD
'mypasswordhere';

However, your app probably shouldn't be using the postgres account,
instead it should be using a different account (and database)

    CREATE USER someuser WITH PASSWORD 'somepassword';
    CREATE DATABASE somedatabase WITH OWNER someuser;

then use that user and database instead.
.....