Re: Intermittent Postgres Connection refused Errors (JDBC)

On 5/1/07, Srinivas Kotapally <ksrinivas(at)bisil(dot)com> wrote:
>
> Hi
>
> I am managing an application that uses the Postgres backend. Of late we
> have started getting connection refused errors every now and then. We have
> not been able to identify the cause of this. Any hints or known bugs that I
> should be aware of? Thanks for any help extended!
>
> Regards
>
> Srinivas
>
> Here is the environment I work in:
> Application is a Java app residing on a web server and is running on
> Tomcat.
> Versions:
> jdk: 1.5.0_02
> Tomcat 5.5.23
> Web server: httpd-2.0.52-28.ent.centos4
> Kernel: Linux version 2.6.9-42.0.10.ELsmp (mockbuild(at)builder5(dot)centos(dot)org)
> (gcc version 3.4.6 20060404 (Red Hat 3.4.6-3)) #1 SMP Tue Feb 27 09:40:21
> EST 2007
> Postgres: 8.1.8 (64 bit version) -
> postgresql-libs-8.1.8-1PGDG
> postgresql-8.1.8-1PGDG
> postgresql-server-8.1.8-1PGDG
> postgresql-contrib-8.1.8-1PGDG
>
> We use the JDBC2 driver that comes with Postgres.
>
> The specific error we get is:
>
> CDBConnectionPool.newConnection() : SQLException=
> org.postgresql.util.PSQLException: Connection refused. Check that the
> hostname and port are correct and that the postmaster is accepting TCP/IP
> connections.
>

Are you exceeding the maximum allowed connections in PostgreSQL? I would
start by checking the PostgreSQL logs. If nothing shows up, it may be a
network or application configuration issue.

-Aaron

--
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================