| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Bradley DeJong <bpd0018(at)gmail(dot)com> |
| Cc: | Andreas 'ads' Scherbaum <ads(at)pgug(dot)de>, pgsql-www(at)postgresql(dot)org |
| Subject: | Re: Addendum to the FAQ |
| Date: | 2018-10-15 17:49:00 |
| Message-ID: | 20181015174900.GA22602@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)momjian(dot)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 +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christophe Pettus | 2018-10-15 17:52:33 | Re: Addendum to the FAQ |
| Previous Message | Daniel Gustafsson | 2018-10-15 11:41:32 | Re: Synonyms in doc search |