Re: Standby WAL Cleanup?

From: Don Seiler <don(at)seiler(dot)us>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Standby WAL Cleanup?
Date: 2017-08-14 21:32:09
Message-ID: CAHJZqBDhthbVRfp+ojXd4FahAgcvm95eSA=uze1AszPceY9dnQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Aug 14, 2017 at 4:26 PM, Guillaume Lelarge <guillaume(at)lelarge(dot)info>
wrote:

> 2017-08-14 23:08 GMT+02:00 Don Seiler <don(at)seiler(dot)us>:
>>
>> However on a standby, my understanding is that the archive_command
>> parameter is not used. I know for sure that it would fail on the standby
>> that I'm looking at.
>>
>
> Well, then, you need to check your facts :) Since 9.5, a standy can
> archive WAL files. See archive_mode and its "new" value : always.
>

Fair enough. The DB that I'm looking at is on 9.2. I'll definitely keep
this in mind as we plan to upgrade later this year. Thanks for the heads-up!

Don.

--
Don Seiler
www.seiler.us

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Aleksander Kamenik 2017-08-15 05:57:12 Re: avoiding split brain with repmgr
Previous Message Guillaume Lelarge 2017-08-14 21:26:36 Re: Standby WAL Cleanup?