[pgpool-general: 8626] Re: Trying to understand $ARCHIVEDIR
Ron
ronljohnsonjr at gmail.com
Sat Mar 4 06:14:22 JST 2023
On 3/3/23 02:09, Bo Peng wrote:
> hello,
>
> On Wed, 1 Mar 2023 06:03:08 -0600
> Ron <ronljohnsonjr at gmail.com> wrote:
>
>> On 2/28/23 19:52, Bo Peng wrote:
>>> Hello,
>>>
>>>> Checking out increasing disk usage on my primary db server I noticed log
>>>> archives were building up in ~postgres/archivedir. It's been a while since
>>>> I set up my pgpool-II cluster so I had to do some digging to understand why
>>>> the logs are being archived there, and it turns out it's because they're
>>>> referenced in my follow_primary.sh (as copied from the sample script).
>>>>
>>>> Assuming I'm happy with my backup strategy in general, is there a reason I
>>>> need to keep these archived files? Do I need the archive_command at all?
>>> It is not necessary to enable archive mode.
>>> If you have your backup strategy or if you are using replication slot,
>>> you can disable archive mode to save disk space.
>> Is this true when using watchdog in a cluster (which says that archive mode
>> must be on)?
>>
>> https://www.pgpool.net/docs/43/en/html/example-cluster.html
> I don't think watchdog is related to archive mode.
> Could you show the documentaion?
It's in the documentation page mentioned above.
Specifically, Table 8-3 and section 8.2.4 "Before starting".
--
Born in Arizona, moved to Babylonia.
More information about the pgpool-general
mailing list