Re: Getting error "IST FATAL: the database system is in recovery mode"

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Getting error "IST FATAL: the database system is in recovery mode"
Date: 2015-07-17 13:19:05
Message-ID: CAB7nPqQatWUrBTkYesB=1N0KF2xovPBsTJRXA_6H+jw5-wq67Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jul 17, 2015 at 9:47 PM, Sachin Srivastava
<ssr(dot)teleatlas(at)gmail(dot)com> wrote:
> I am getting the below error in my database pg_log file and also I am unable
> to open the database.
> "IST FATAL: the database system is in recovery mode"
> I am using postgresql version 9.1 on Centos 6.6. Kindly suggest why this
> problem is coming.

You are trying to connect to a system that is performing a crash
recovery, meaning that it crashed, and you cannot connect to it, or
this is a standby node that is not set up as a read-only hot standby.
--
Michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-07-17 13:24:12 Re: Getting error "IST FATAL: the database system is in recovery mode"
Previous Message Melvin Davidson 2015-07-17 13:12:29 Re: Backup fatal issue