Re: Addendum to the FAQ - Mailing list pgsql-www

From Bruce Momjian
Subject Re: Addendum to the FAQ
Date
Msg-id 20181015174900.GA22602@momjian.us
Whole thread Raw
In response to Re: Addendum to the FAQ  ("Bradley DeJong" <bpd0018@gmail.com>)
Responses Re: Addendum to the FAQ  (Christophe Pettus <xof@thebuild.com>)
List pgsql-www
On Sun, Sep 30, 2018 at 12:20:02PM +0000, Bradley DeJong wrote:
> On 2018-09-29, Andreas 'ads' Scherbaum wrote ...
> > Answer:
> > Under no circumstances must files in the pg_xlog/ directory be removed, they
> are essential
> > for the database operation. The files in this directory store the transaction
> log, without
> > these files the database can't recover after a crash or shutdown.
> 
> Those sentences use a fairly sophisticated/complex sentence structure.
> As a simplified alternative, I suggest ...
> 
> Answer:
> Do not remove any files from the pg_xlog directory. They store the transaction
> log. Without
> the transaction log, the database can't recover after a crash or shutdown.

Now that the directory is named pg_wal in PG 10, we might not need this.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +


pgsql-www by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Synonyms in doc search
Next
From: Christophe Pettus
Date:
Subject: Re: Addendum to the FAQ