Re: Postgres-JDBC question

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.