Re: Database goes in recovery mode

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Ashok Kumar Tiwari <ashokt(at)ohumhealthcare(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Database goes in recovery mode
Date: 2017-10-13 15:37:44
Message-ID: CAOR=d=0F6JQ6ysffnwTLn7_DjiNFJRUxHf3yrDMSO6VjWvxfUg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Oct 13, 2017 at 7:31 AM, Ashok Kumar Tiwari
<ashokt(at)ohumhealthcare(dot)com> wrote:
>
> Hello team,
>
> My database goes in recovery mode every day three to four time , i am not able to find the reason, db basic configuration is max_connection = 1000 , db size 100GB and configure barman for backup. please help me.

Check your server logs for the out of memory killer. With max conns of
1000 it's quite possible your machine is running out of memory.

Also please post any changed values in postgresql.conf

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2017-10-14 13:13:02 Re: Database goes in recovery mode
Previous Message Scott Mead 2017-10-13 13:32:19 Re: Increase retention period of a table in database