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.