Re: Postgres DB is failed due to pg_Xlog is continues full.

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: Yogesh Sharma <yogeshraj95(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres DB is failed due to pg_Xlog is continues full.
Date: 2017-09-14 04:30:47
Message-ID: 8a42afd6-3280-6f34-4d0e-b13fb2b3351d@archidevsys.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 14/09/17 16:11, Yogesh Sharma wrote:
> >>What you could do is copying its contents to a large disk, and then
> allow it to recover from the crash.
>  I will copy the PGDATA into large disk. After that it is require to
> execute some specific command or automatically recovery will start?
> If any command is require to execute please let me know.
> Regards,
> Yogesh
If appropriate, can insert comments directly after the associated text.

>
> On Thursday, September 14, 2017, Michael Paquier
> <michael(dot)paquier(at)gmail(dot)com <mailto:michael(dot)paquier(at)gmail(dot)com>> wrote:
>
> On Thu, Sep 14, 2017 at 12:44 PM, John R Pierce
> <pierce(at)hogranch(dot)com <javascript:;>> wrote:
>
[...]

Hi Yogesh,

Please post followups to emails at the end, called 'bottom posting' like
this.  It is the convention in the Postgres mailing lists, and makes it
easier to get the context.

If a lot of the the previous text is no longer relevant it can be
omitted and replaced by '[...]'.

Thanks,
Gavin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message milist ujang 2017-09-14 05:35:18 BDR, near xid wraparound, a lot of files in pg_subtrans directory
Previous Message John R Pierce 2017-09-14 04:26:22 Re: Postgres DB is failed due to pg_Xlog is continues full.