Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 29BBA2E0047 for ; Mon, 25 Feb 2008 10:07:48 -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 73217-09 for ; Mon, 25 Feb 2008 10:07:37 -0400 (AST) X-Greylist: delayed 00:06:09.495504 by SQLgrey-1.7.5 Received: from ti-out-0910.google.com (ti-out-0910.google.com [209.85.142.186]) by postgresql.org (Postfix) with ESMTP id 402112E0046 for ; Mon, 25 Feb 2008 10:07:36 -0400 (AST) Received: by ti-out-0910.google.com with SMTP id y6so950322tia.5 for ; Mon, 25 Feb 2008 06:07:35 -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:sender:to:subject:mime-version:content-type:x-google-sender-auth; bh=aX376XyzlE7VsE5E0K9S/TtEvioH8sAWki2NKJ/R0VI=; b=dQAy1etcZROJ0E+IImHUz9vHdT/URTm2O2kUBjJffoLjxCID5WPcdvmUYSTOKOOkFF038LeKhn1NIS8jVaDWfMSn2Q3CH+0f6ZQuDm/EPSHZm/UbxClbrmoCIpz5TSzjHD1KLOaeSKrpKQ+qGx9Yt3ZqQsxcYujVXndJPOsGJrc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:sender:to:subject:mime-version:content-type:x-google-sender-auth; b=YvyJ/k//mEGvbplTG1giESMbumTHe2rKBZvUxyyd5yGVKIssQM/9MhPi/uARj1B1IEzuEsxqpG79JDwQZx9KXH/gTYKXWiE6SDY1ZENjR4EUdiwtaxDi5nAOLuuxoUfB/ydY2YKWSAnQ3vMUXXIlnl3X6Xp3S9TEGFZX3YE0EXc= Received: by 10.110.47.7 with SMTP id u7mr2012033tiu.58.1203948084619; Mon, 25 Feb 2008 06:01:24 -0800 (PST) Received: by 10.70.89.12 with HTTP; Mon, 25 Feb 2008 06:01:24 -0800 (PST) Message-ID: Date: Mon, 25 Feb 2008 08:01:24 -0600 From: "Aaron Bono" To: pgsql-admin@postgresql.org Subject: System in Recovery Mode MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2180_6437648.1203948084513" X-Google-Sender-Auth: 56e447067a866189 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/323 X-Sequence-Number: 28397 ------=_Part_2180_6437648.1203948084513 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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? Thanks! Aaron -- ================================================================== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ================================================================== ------=_Part_2180_6437648.1203948084513 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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?

Thanks!
Aaron

--
==================================================================
  Aaron Bono
  Aranya Software Technologies, Inc.
  http://www.aranya.com
  http://codeelixir.com
================================================================== ------=_Part_2180_6437648.1203948084513--