pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: 'Srinivas Kotapally' <ksrinivas@bisil.com>
To: 'Tom Lane' <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: Intermittent Postgres Connection refused Errors (JDBC)
Date: Tue, 1 May 2007 22:12:46 -0400
Message-ID: <01d101c78c5f$615b1790$800101df@srinilaptop> (raw)
In-Reply-To: <1845.1178059892@sss.pgh.pa.us>
References: <016601c78bf3$80819c00$800101df@srinilaptop>
	<1845.1178059892@sss.pgh.pa.us>

Hi Tom

I installed CentOS 4.4 final late last year.  The kernel version was the latest
about a year back.  I have been running yum updates and applying patches
regularly.  Can you give me any ideas on how to troubleshoot (and establish that
this issue is due to a kernel bug) the kernel packet drops?  I am beginning to
think it is a firewall related issue.  But I have been unable to replicate the
issue!

I have been monitoring the firewall logs (could not find much there).  Maybe I
will also sifting through the messages log on the servers.

Will post if I find anything!

Thanks

Srini 

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us] 
Sent: Tuesday, May 01, 2007 6:52 PM
To: ksrinivas@coriendo.com
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Intermittent Postgres Connection refused Errors (JDBC) 

"Srinivas Kotapally" <ksrinivas@coriendo.com> writes:
> 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!

"Connection refused" means it was refused at the kernel level; if the postmaster
had rejected the connection the message would be different.
So you need to be looking for OS-level issues.  Given that you seem to be
running a rather hoary kernel (2.6.9 is a ways back no?), maybe an update there
is indicated.  Firewall problems are a possibility too.

			regards, tom lane




view thread (8+ messages)

Message-ID: <01d101c78c5f$615b1790$800101df@srinilaptop>
Permalink:  ../01d101c78c5f$615b1790$800101df@srinilaptop/
Also on:    postgresql.org/message-id/01d101c78c5f$615b1790$800101df@srinilaptop

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ksrinivas@bisil.com, tgl@sss.pgh.pa.us
  Subject: Re: Intermittent Postgres Connection refused Errors (JDBC)
  In-Reply-To: <01d101c78c5f$615b1790$800101df@srinilaptop>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox