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
2 messages in org.postgresql.pgsql-jdbcRe: password authentication failure
