|
Home > Archive > PostgreSQL JDBC > September 2005 > Problem getting a connection with Postgres 8.0.3
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problem getting a connection with Postgres 8.0.3
|
|
| Pedro Mendes 2005-09-28, 8:25 pm |
| Hello,
I'm having some problems connecting my jsp application using driver
postgresql-8.0-312.jdbc3 to a local postgresql database server. The
connection seems to be always refused whatever the user and/or database.
This is the code I wrote:
try
{
Class.forName("org.postgresql.Driver");
Connection db =
DriverManager.getConnection("jdbc:postgresql://192.168.8.2/cgm","cgm","esper
anca");
for( SQLWarning warn = db.getWarnings(); warn != null; warn =
warn.getNextWarning() )
{
System.out.println( "SQL
Warning:" ) ;
System.out.println( "State
: " + warn.getSQLState() ) ;
System.out.println(
"Message: " + warn.getMessage() ) ;
System.out.println( "Error
: " + warn.getErrorCode() ) ;
}
...
This is the error returned:
Message: Connection refused. Check that the hostname and port are correct
and that the postmaster is accepting TCP/IP connections.
Error : 0
Hopping for an answer
Pedro Mendes - Portugal
| |
| Kris Jurka 2005-09-28, 8:25 pm |
|
On Wed, 28 Sep 2005, Pedro Mendes wrote:
> I'm having some problems connecting my jsp application using driver
> postgresql-8.0-312.jdbc3 to a local postgresql database server. The
> connection seems to be always refused whatever the user and/or database.
>
> DriverManager.getConnection("jdbc:postgresql://192.168.8.2/cgm","cgm","esper
> anca");
>
> Message: Connection refused. Check that the hostname and port are correct
> and that the postmaster is accepting TCP/IP connections.
>
This is a tcpip error message, caused by the server not listening on the
desired port. What have you set listen_addresses in postgresql.conf?
Probably only localhost. Try adding the server's external address or * to
listen on all available addresses.
Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
| |
| Nelson Arape 2005-09-29, 3:24 am |
| El Mié 28 Sep 2005 18:25, Kris Jurka escribió:
> On Wed, 28 Sep 2005, Pedro Mendes wrote:
>
> This is a tcpip error message, caused by the server not listening on the
> desired port. What have you set listen_addresses in postgresql.conf?
> Probably only localhost. Try adding the server's external address or * to
> listen on all available addresses.
>
> Kris Jurka
Also make sure that you run postmaster with the -i parameter, so postgres
server can accept TCPIP connections
Nelson Arape
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
|
|
|
|
|