Here's my situation: I've installed Postgres 8.1.3 and tomcat 5.5.16
and all the dependencies, I'm on a Win 2k3 box. I can connect using the
postgres Admin program just find and there are no problems. I can run
my web app on a different box and everything connects just fine.
However, when I run the web app on the same box that contains the
database I get a connection refused error.
Here's my context.xml:
<?xml version="1.0" encoding="UTF-8"?>
<Context crossContext="true" debug="1" docBase="NeuView" path="/Neuview"
reloadable="true">
<Resource auth="Container" driverClassName="org.postgresql.Driver"
maxActive="20" maxIdle="10" maxWait="-1" name="jdbc/postgres"
password="..." type="javax.sql.DataSource"
url="jdbc:postgresql://192.168.27.40:5432/neuview" username="..."/>
</Context>
I've tried using 127.0.0.1, localhost and the actual IP (above) in the
url, but that doesn't seem to help. I've also tried different users and
passwords, still no go.
Here's the postgres.conf file (relating to tcp/ip):
listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of
addresses;
# defaults to 'localhost', '*' =
all
port = 5432
...
authentication_timeout = 60 # 1-600, in seconds
ssl = off
password_encryption = on
...
tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds;
# 0 selects the system default
tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds;
# 0 selects the system default
tcp_keepalives_count = 0 # TCP_KEEPCNT;
# 0 selects the system default
Here's the pg_hba.conf as well:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
host all all 0.0.0.0/0 md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
#host all all ::1/128 md5
This problem really baffles me, and is getting a little frustrating.
Any one have any ideas?
-Jason Porter