Received: from mail.interchange.ca (ns.interchange.ca [216.126.79.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e74InEG26887 for ; Fri, 4 Aug 2000 14:49:14 -0400 (EDT) Received: by mail.interchange.ca (Fastmailer, from userid 555) id CF5F79B0B; Fri, 4 Aug 2000 14:48:47 -0400 (EDT) MIME-Version: 1.0 Message-Id: <398B100F.0000AB.63030@frodo.searchcanada.ca> Content-Type: Multipart/Mixed; boundary="------------Boundary-00=_BX6SI4071OVNTT4D7TH0" To: pgsql-sql@postgresql.org Subject: Database in recovery mode From: "Michael Richards" X-Fastmail-IP: 24.42.110.18 Date: Fri, 4 Aug 2000 14:48:47 -0400 (EDT) X-Archive-Number: 200008/42 --------------Boundary-00=_BX6SI4071OVNTT4D7TH0 Content-Type: Text/Plain Content-Transfer-Encoding: 7bit Hi. I've got a postgres system that keeps going into recovery mode. I can't really find any docs on this. All of the postgres processes will be in the STOP state and when I try to connect it will say "The database is in recovery mode". I suspect there is a query that is causing it to crash in some specific way that causes it. This is happening about once per day. Any ideas? -Michael _________________________________________________________________ http://fastmail.ca/ - Fast Free Web Email for Canadians --------------Boundary-00=_BX6SI4071OVNTT4D7TH0--