Thread: password authentication failure

I was able able to create my database and create a Admin role with a password with which i was able to sign on to the database using the prompt. However, an attempt to access the database via my java application using jdbc gave this response

 

please assist

Try to connect to the database using the command-line tool and
specifying the host parameter, to force a network connection (same type
of connection that the JDBC driver uses).

So run:
psql -h whatever_server_jdbc_uses

If that doesn't work, then you have an authentication problem; read the
PG documentation about configuring authentication with pg_hba.conf.

If it does work, then please supply the version of the driver you're
using, the JDBC URL you're using, a code snippet showing how you're
attempting to connect, and some basic info about your server (version,
host it's running on).

-- Mark Lewis


On Thu, 2006-07-13 at 16:45 +0100, System Consult wrote:
> I was able able to create my database and create a Admin role with a
> password with which i was able to sign on to the database using the
> prompt. However, an attempt to access the database via my java
> application using jdbc gave this response
>
> FATAL: password authentication failed for user "Admin"
>
>
>
> please assist
>