"Jonathan Mast" <jonathan(dot)h(dot)mast(at)gmail(dot)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.
> 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
In response to
pgsql-jdbc by date
|Next:||From: Oliver Jowett||Date: 2008-01-03 18:49:36|
|Subject: Re: Timestamp problem|
|Previous:||From: Jonathan Mast||Date: 2008-01-03 15:47:02|
|Subject: Re: Permissions problem|