From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
---|---|
To: | Israel Brewster <israel(at)ravnalaska(dot)net> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: WAL File archive time |
Date: | 2016-12-06 04:48:18 |
Message-ID: | CAB7nPqRC9pMLoi+YTgmm0YeJjyhQryao8ZX+KgFx04Fm4Rny-A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Dec 6, 2016 at 7:24 AM, Israel Brewster <israel(at)ravnalaska(dot)net> wrote:
> Simple question: are WAL files archived when full, or when recycled?
When full.
> That is, are the WAL archive files "up-to-date" other than the current WAL file,
> or will the archives always be wal_keep_segments behind?
WAL archives are kept up to date, meaning that all the segments older
than the one being written are archived (well perhaps not if the
archiver lags behind). wal_keep_segments numbers the number of
segments kept in pg_xlog past the last completed checkpoint.
--
Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph Brenner | 2016-12-06 04:50:42 | Re: Select works only when connected from login postgres |
Previous Message | Melvin Davidson | 2016-12-06 04:03:11 | Re: Index size |