Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E8FA12E003A for ; Mon, 25 Feb 2008 12:39:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 43297-06 for ; Mon, 25 Feb 2008 12:39:22 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.178]) by postgresql.org (Postfix) with ESMTP id 0A15E2E0046 for ; Mon, 25 Feb 2008 12:39:21 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so1955196waf.5 for ; Mon, 25 Feb 2008 08:39:20 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=Vzlagdw+g18jfdyfTn9tsExuoDuq5TllChmr5lY8qWs=; b=ARibjVqxTJvZdb2WNiFXpJylM/hrZK2NDvLHA66OkS6iaZrgI5/dYqwy0CEmQliJ+OOtq4ReFALl3FnavfUve+7bWMt/oZwJw7VQ4hZLGfTC1mIJWugOqx9reF3iTAn71vNS3kDjicmdfkw2Ue0ML7P7MZP9+3yR//11qxxrp00= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=oYn1VADqEcOQ2VZnrFln5hRdHCv7Rh+eNoZjuVnPXA0F1S6D9k4Lt29InDd+8Fu0UB1b6sATfm6WVlVTDL2CkN+yb0ui5gWbpXznyKN3/qstXRfCj6lR0AP6IWXEaXlZuKUJFTsMhHqjihRS7Hep4B7ajakP28jLdA57Cpn/Sf4= Received: by 10.115.89.1 with SMTP id r1mr3853689wal.8.1203957560807; Mon, 25 Feb 2008 08:39:20 -0800 (PST) Received: by 10.114.133.6 with HTTP; Mon, 25 Feb 2008 08:39:20 -0800 (PST) Message-ID: Date: Mon, 25 Feb 2008 10:39:20 -0600 From: "Scott Marlowe" To: "Aaron Bono" Subject: Re: System in Recovery Mode Cc: Postgres In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/318 X-Sequence-Number: 28392 On Mon, Feb 25, 2008 at 8:11 AM, Aaron Bono wrote: > Our database was going along just fine this morning when, out of the blue, > we started getting the following errors: > > FATAL: the database system is in recovery mode > > We are using PostgreSQL 8.1.3 on CentOS. I was the only person on the > machine and had recently started a small batch that had just finished > querying and updating the database. This batch runs constantly and has not > been changed in months. > > What are the things that could be causing this? I'm not saying it definitely is the problem, but you are missing 2 years of updates. 8.1.11 came out just last month, 8.1.3 came out 2 years ago.