connect to remote db - Mailing list pgsql-general

From Yi LIN
Subject connect to remote db
Date
Msg-id Pine.GSO.4.44.0308131655310.19914-100000@willy
Whole thread Raw
List 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





pgsql-general by date:

Previous
From: expect
Date:
Subject: importing db as text files
Next
From: Bruno Wolff III
Date:
Subject: Re: importing db as text files