| 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: | Whole Thread | Raw Message | 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
| 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 |