Message-ID: <4C06CD8F.4030304@hogranch.com>
Date: Wed, 02 Jun 2010 14:30:55 -0700
From: John R Pierce <pierce@hogranch.com>
User-Agent: Thunderbird 2.0.0.24 (Windows/20100228)
MIME-Version: 1.0
To: undisclosed-recipients:;
Subject: Re: Exception while accessing database
References: <AANLkTilPLQavzfAVQvaWJOTlpG5SztbzXKYYwmCmHq_s@mail.gmail.com>
In-Reply-To: <AANLkTilPLQavzfAVQvaWJOTlpG5SztbzXKYYwmCmHq_s@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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