Skip site navigation (1) Skip section navigation (2)

Re: Postgres-JDBC question

From: Philip Yarra <philip(at)utiba(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Cc: "Sean" <sean(dot)conlon(at)4expertsolutions(dot)com>
Subject: Re: Postgres-JDBC question
Date: 2006-01-28 03:13:54
Message-ID: 200601281413.54351.philip@utiba.com (view raw or flat)
Thread:
Lists: 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.


In response to

pgsql-jdbc by date

Next:From: Georg HintermaierDate: 2006-01-28 10:22:56
Subject: copy patch question: byte format and efficiency
Previous:From: Mark LewisDate: 2006-01-27 18:41:22
Subject: Re: Postgres-JDBC question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group