"Jonathan Mast" <jonathan.h.mast@gmail.com> writes:
> When run locally (with Tomcat on the Windows box) the webapp connects
> correctly to the servers and accesses the pgsql database with no problems.
> When deployed on the server, the webapp will not connect to pgsql.
> Errors:
> It will throw an SQLException, but I haven't found it too helpful, it
> basically says "Cannot connect to PostgreSQL" and thats it.
That's pretty useless :-( ... a complaint to the webapp's author
wouldn't be out of line.
In the meantime, I'd bet on either a firewall blocking the connection or
a missing/incorrect entry in the server's pg_hba.conf file for the
remote connection. Try turning on log_connections in the server and
watching its log file when you try the webapp. If you see nothing at
all then it's probably a firewall problem. If you do get a log entry
then it should tell you what's wrong.
regards, tom lane