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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Strange Postgres / Tomcat log on error.



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




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group