Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 471BD2E0054 for ; Mon, 25 Feb 2008 10:11:36 -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 74930-04-4 for ; Mon, 25 Feb 2008 10:11:29 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from gv-out-0910.google.com (gv-out-0910.google.com [216.239.58.185]) by postgresql.org (Postfix) with ESMTP id A40FB2E0052 for ; Mon, 25 Feb 2008 10:11:29 -0400 (AST) Received: by gv-out-0910.google.com with SMTP id y18so484986gvf.7 for ; Mon, 25 Feb 2008 06:11:28 -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=5WflCsV9NQkwD96krVDbp08GZvzrMYMnwaeOwKz5hlQ=; b=gc6LAiDbEdQhM820eWeZ37kGjJCkWogirColi3iFrtTVG6F09H+Zx7duZRydW4akrmMsgHz/fEnMUpFlxh2V7HPxjulyI+YYKibLOX0xopdSarXcnjAPmjcK9ru7kkqv9AnffQMFN7yKZLMMSO9LUjRLo4YRGoBIhS7tKTPFUSw= 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=j7RaQ8Q745xfJefBA/rlt4RABn5eAqL78Wv5dS7w3G9pOjjncPHeCzxgxGg3SUL4230+2tg7no8qhM2l4N16LlZuKZKsJZpIspGCNIs8cc/yCZunbS6IrTun6/8suGrDwRJoI8yk+TWwDwxS+tIChkoVFhCElYPwiaV4Ka+J3go= Received: by 10.142.48.14 with SMTP id v14mr2273023wfv.121.1203948685608; Mon, 25 Feb 2008 06:11:25 -0800 (PST) Received: by 10.70.89.12 with HTTP; Mon, 25 Feb 2008 06:11:25 -0800 (PST) Message-ID: Date: Mon, 25 Feb 2008 08:11:25 -0600 From: "Aaron Bono" To: Postgres Subject: System in Recovery Mode MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2290_17596614.1203948685557" X-Google-Sender-Auth: 2d5e53726d8b71e6 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200802/314 X-Sequence-Number: 28388 ------=_Part_2290_17596614.1203948685557 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_2290_17596614.1203948685557 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_2290_17596614.1203948685557--