Postgres Pro
Downloads
Home   >   mailing lists

Thread: Problem getting a connection with Postgres 8.0.3

Problem getting a connection with Postgres 8.0.3

From
"Pedro Mendes"
Date:

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","esperanca");

 

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

 

 

Re: Problem getting a connection with Postgres 8.0.3

From
Kris Jurka
Date:

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

Re: Problem getting a connection with Postgres 8.0.3

From
Nelson Arape
Date:
El Mié 28 Sep 2005 18:25, Kris Jurka escribió:
> On Wed, 28 Sep 2005, Pedro Mendes wrote:
> > 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

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