Re: pg_xlog keeps growing

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: dhanuj hippie <dhanuj(dot)hippie(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_xlog keeps growing
Date: 2017-02-28 03:46:25
Message-ID: 4A29AE3E-03C2-4DA5-B328-AFCD57D620E6@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> On Feb 27, 2017, at 8:33 PM, dhanuj hippie <dhanuj(dot)hippie(at)gmail(dot)com> wrote:
>
> Hi,
>
> I have a postgres cluster running in hot_standby. I see the pg_xlog is growing over time (may files of size 16 MB each). The replication lag is very less ~2kB, and never goes into a bad state.
> I'm manually resetting this once a while using pg_resetxlog command.
> Is there a way to understand why my system keeps running into this problem ?
>
> Thanks

wal_keep_segments is set to ???

(and version = ???, etc)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message dhanuj hippie 2017-02-28 04:17:13 Re: pg_xlog keeps growing
Previous Message dhanuj hippie 2017-02-28 03:33:41 pg_xlog keeps growing