Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 93E939FB4E9 for ; Tue, 27 Mar 2007 16:32:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 86105-10 for ; Tue, 27 Mar 2007 16:32:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from smtp110.mail.mud.yahoo.com (smtp110.mail.mud.yahoo.com [209.191.85.220]) by postgresql.org (Postfix) with SMTP id 052129FB4DC for ; Tue, 27 Mar 2007 16:32:46 -0300 (ADT) Received: (qmail 69485 invoked from network); 27 Mar 2007 19:32:45 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=Received:X-YMail-OSG:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:Content-Type:Content-Transfer-Encoding; b=zELIKkJvV9OpApjCxRs22EyThroOk7u9SOYsOK7c7A9FvKM7pKzUud6KEvVtq7nrBt+JE0quuLRLXSueL89/QKG2yvuClZOR5vvuKp8MgNvAgVou4pqCKmmjeSm7TmMv8hNM950UiNUGI/R+D/rJKA4sxLI1oSYuhq+JhiLvP34= ; Received: from unknown (HELO ?10.90.2.103?) (burbello3000@200.103.143.8 with plain) by smtp110.mail.mud.yahoo.com with SMTP; 27 Mar 2007 19:32:45 -0000 X-YMail-OSG: 5U6y_t0VM1nrRGL_qQMZ2zOElEILlJqQqCjErsr_nrxQZbXH2Pb_VIAVSjVOb5iDNN8tcqMZpA-- Message-ID: <46097157.3040100@yahoo.com.br> Date: Tue, 27 Mar 2007 16:32:39 -0300 From: "Alexander B." User-Agent: Thunderbird 1.5.0.7 (X11/20060911) MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: Strange behavior Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/214 X-Sequence-Number: 25038 Hi, some developers were using the database, and suddenly no one could connect. Just only some connections that was established before. As soon as I was advised, I noticed that no postgres process were present, just only connections and they could run queries normally. Like this: desenv:~# ps -ef |grep postgres postgres 28010 27886 0 15:28 ? 00:00:00 postgres: desenv fabrica 10.90.2.116(57749) idle in transaction postgres 28013 27886 0 15:29 ? 00:00:00 postgres: desenv fabrica 10.90.2.112(51326) idle postgres 28051 27886 0 15:33 ? 00:00:01 postgres: desenv fabrica 10.90.2.115(51671) idle in transaction postgres 28110 27886 0 15:36 ? 00:00:00 postgres: desenv teste 10.90.2.14(48903) idle in transaction postgres 28134 27886 0 15:36 ? 00:00:01 postgres: desenv fabrica 10.90.2.115(60894) idle in transaction Strange that no log about what happened, were written. When I tried to stop, no process message was returned. Then, I started postgres again, and everything come back to run. Is there some patch to apply? Is it normal? Using PostgreSQL 8.1.4 on x86_64-pc-linux-gnu, compiled by GCC cc (GCC) 3.3.5 (Debian 1:3.3.5-13) Thanks Alexander _______________________________________________________ Yahoo! Mail - Sempre a melhor opção para você! Experimente já e veja as novidades. http://br.yahoo.com/mailbeta/tudonovo/