Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 63B98B5DBE4
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Thu, 18 Aug 2011 01:39:05 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 44134-01
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Thu, 18 Aug 2011 04:38:58 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from softlayer.compulab.co.il
	(50.23.254.54-static.reverse.softlayer.com [50.23.254.54])
	by mail.postgresql.org (Postfix) with ESMTP id 83B8FB5D803
	for <pgsql-general@postgresql.org>;
	Thu, 18 Aug 2011 01:38:58 -0300 (ADT)
Received: from [62.90.235.247] (port=37030 helo=zimbra-mta.compulab.co.il)
	by softlayer.compulab.co.il with esmtp (Exim 4.69)
	(envelope-from <sim@compulab.co.il>) id 1QtuNc-0007Z4-Tx
	for pgsql-general@postgresql.org; Thu, 18 Aug 2011 07:38:57 +0300
Received: from localhost (localhost.localdomain [127.0.0.1])
	by zimbra-mta.compulab.co.il (Postfix) with ESMTP id D15667E925D
	for <pgsql-general@postgresql.org>;
	Thu, 18 Aug 2011 07:38:55 +0300 (IDT)
X-Virus-Scanned: amavisd-new at compulab.co.il
Received: from zimbra-mta.compulab.co.il ([127.0.0.1])
	by localhost (zimbra-mta.compulab.co.il [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id nR8K+gdJKUVY for <pgsql-general@postgresql.org>;
	Thu, 18 Aug 2011 07:38:55 +0300 (IDT)
Received: from [10.1.1.27] (sim-pc.compulab.local [10.1.1.27])
	by zimbra-mta.compulab.co.il (Postfix) with ESMTP id 9916F7E925A
	for <pgsql-general@postgresql.org>;
	Thu, 18 Aug 2011 07:38:55 +0300 (IDT)
Message-ID: <4E4C9744.4060407@compulab.co.il>
Date: Thu, 18 Aug 2011 07:38:28 +0300
From: Sim Zacks <sim@compulab.co.il>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.2.18) Gecko/20110617 Lightning/1.0b2 Thunderbird/3.1.11
MIME-Version: 1.0
To: PostgreSQL general <pgsql-general@postgresql.org>
Subject: Re: Using Postgresql as application server
References: 
 <CAN2Y=uPjF14F5A9JXj02_vaPw4TMR0WGQid_w80xt4sC8o4qGg@mail.gmail.com>
	<4E498536.9080109@darrenduncan.net>
	<008301cc5b95$e287b120$a7971360$@yahoo.com>
	<4E49A208.5070604@darrenduncan.net>
	<CAKt_ZftgpuGNbyxvQ_Bf0QrjahY5=HbxcoUUuxUYCdKbY=rp0g@mail.gmail.com>
	<4E49EC4D.1090707@darrenduncan.net>
	<4E4B6828.1050506@compulab.co.il>
	<46EC79AF-3685-484E-AABE-E25969C23D56@elevated-dev.com>
In-Reply-To: <46EC79AF-3685-484E-AABE-E25969C23D56@elevated-dev.com>
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-AntiAbuse: This header was added to track abuse,
	please include it with any abuse report
X-AntiAbuse: Primary Hostname - softlayer.compulab.co.il
X-AntiAbuse: Original Domain - postgresql.org
X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12]
X-AntiAbuse: Sender Address Domain - compulab.co.il
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.379 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	HTML_MESSAGE=0.001, KHOP_DYNAMIC=0.797, MIME_HTML_ONLY=0.723
X-Spam-Level: 
X-Archive-Number: 201108/577
X-Sequence-Number: 178859

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html style="direction: ltr;">
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
    <style>body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
  </head>
  <body style="direction: ltr;"
    bidimailui-detected-decoding-type="latin-charset" bgcolor="#ffffff"
    text="#000000">
    On 08/17/2011 05:34 PM, Scott Ribe wrote:
    <blockquote
      cite="mid:46EC79AF-3685-484E-AABE-E25969C23D56@elevated-dev.com"
      type="cite">
      <pre wrap="">On Aug 17, 2011, at 1:05 AM, Sim Zacks wrote:

</pre>
      <blockquote type="cite">
        <pre wrap="">One problem we have with LISTEN/NOTIFY (and I haven't found the cause for this yet) is every once in a while my daemon stops listening. It may be after a month of use or longer, and may be caused by the database being restarted or something similar. When the daemon stops listening, it doesn't give any errors or indication that it isn't working anymore.
</pre>
      </blockquote>
      <pre wrap="">
So your daemon has a bug. When the database is restarted, connections will be closed, and the daemon should certainly notice that. Of course the cause may be something else, but either way I doubt it's a problem with NOTIFY/LISTEN.
</pre>
    </blockquote>
    <p>The point was not whether I have a bug in an external
      application, the point is that I need an external application
      which creates more overhead and another point of failure in the
      application stack. <br>
    </p>
  </body>
</html>