connect to remote db

From: Yi LIN <ylin30(at)cs(dot)mcgill(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: connect to remote db
Date: 2003-08-13 21:05:50
Message-ID: Pine.GSO.4.44.0308131655310.19914-100000@willy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,

I want to connect to database repl_isar located in host isar from host
willy. So I wrote:

String url = "jdbc:postgresql://isar/repl_isar";
conn = DriverManager.getConnection(url,username,password);

But it fails by given error both in postmaster running repl_isar and local
site willy.

java.sql.SQLException: User authentication failed

If I tried local database url="repl_willy", the same username and password
work well.

I did run "createuser" script and even run SQL "create user ..".

What do I missed?

Thanks,

Yi Lin

Browse pgsql-general by date

  From Date Subject
Next Message Kathy zhu 2003-08-13 21:12:39 Re: Sorting Problem
Previous Message Tom Lane 2003-08-13 20:23:30 Re: SET TIME ZONE with GMT+X notation