Re: Postgres-JDBC question - Mailing list pgsql-jdbc

From Philip Yarra
Subject Re: Postgres-JDBC question
Date
Msg-id 200601281413.54351.philip@utiba.com
Whole thread Raw
In response to Postgres-JDBC question  ("Sean" <sean.conlon@4expertsolutions.com>)
List pgsql-jdbc
On Sat, 28 Jan 2006 01:31 am, Sean wrote:
> and can connect my app and the db when using localhost, but when I try to
> connect via an ip address, it blows up telling me that the connection was
> refused.  I have set the postmaster to listen for TCP/IP connections, but
> still does not work.  Any suggestions?

In postgresql.conf, the default config is to listen only on localhost IP
address (probably listen_addresses will be set to default value and commented
out). Change it so that is reads:

listen_addresses = '*'

and re-start the DB.

As Mark mentioned, you may also want to review your pg_hba.conf file.

Regards, Philip.

--

"Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it." - Brian W. Kernighan

-----------------
Utiba Pty Ltd
This message has been scanned for viruses and
dangerous content by Utiba mail server and is
believed to be clean.


pgsql-jdbc by date:

Previous
From: Mark Lewis
Date:
Subject: Re: Postgres-JDBC question
Next
From: Georg Hintermaier
Date:
Subject: copy patch question: byte format and efficiency