On 12/10/2018 07:37 AM, David Steele wrote:
> On 12/9/18 5:24 PM, Ron wrote:
>> On 12/09/2018 01:10 PM, Stephen Frost wrote:
>>> You can address that risk by enabling archive_timeout, which will make
>>> PostgreSQL archive the WAL file even if it isn't full after a certain
>>> amount of time, reducing the potential data loss window.
>> I thought checkpoint_timeout forced a WAL switch.
> Checkpoints do not automatically switch WAL. archive_timeout is the way
> to go.
Thanks for the clarification.
--
Angular momentum makes the world go 'round.