From: | "Nick Fankhauser" <nickf(at)ontko(dot)com> |
---|---|
To: | "Yang Soon Chiao" <yangsc(at)tntsb(dot)com>, <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: postgres- connection refuse |
Date: | 2003-09-09 12:24:57 |
Message-ID: | NEBBLAAHGLEEPCGOBHDGGEGNIFAA.nickf@ontko.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Since pgsql doesn't use a tcp/ip connection by default, it can work when a
network connection is not allowed.
To force pgsql to use tcp/ip for a connection, us the -h param:
psql -h <local.server.name> <dbname>
If you can't connect this way, then you should be looking at the pg_hba.conf
file. In particular, make sure you are set up well for localhost.
If you *can* connect this way, then you have the auth set up fine in pg_hba
and you should be looking for the problem in your JDBC code.
-Nick
-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Yang Soon Chiao
Sent: Tuesday, September 09, 2003 6:09 AM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] postgres- connection refuse
This is my first time using postgres. Everything work fine when I use psql
at the bin, however when I try to connect using java, I get this message.
Connection refused. Check that the hostname and port are correct and that
the postmaster is accepting TCP/IP connections.
- It seem like I have the problem with hostname and port but I don't know
how to tune it. (I've modify my postgresql.conf set tcpip_socket = true but
still cannot work).
- Here is how my code looks like
conn = DriverManager.getConnection("jdbc:postgresql:mydb","", "");
(I'm not connecting to any web server)
Please help and thanks in advance.
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Thomas | 2003-09-09 13:32:08 | Re: JBoss w/int8 primary keys in postgres ... |
Previous Message | Paul Thomas | 2003-09-09 11:47:43 | Re: postgres- connection refuse |