From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
---|---|
To: | krishna chaitanya <krish050591(at)gmail(dot)com> |
Cc: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Deleting unwanted wal files |
Date: | 2017-08-17 23:26:12 |
Message-ID: | CAB7nPqRvXKet=PtduqVPXVOD3e1MNp9sYamrHVfAeJkP8ne5gw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Aug 18, 2017 at 12:43 AM, krishna chaitanya
<krish050591(at)gmail(dot)com> wrote:
> Thanks for your reply,
Please do not top-post, this is not the style of this mailing list.
> but will pg_basebackup generate a .backup file when
> scheduled in cron job so that i can give that as input to pg_archivecleanup.
Yes.
> Also if i give archive_cleanup_command in recovery.conf will it check the
> presence of recovery.conf file automatically and execute the command from
> that file ?
You can feed a backup history file name to pg_archivecleanup, it will
then reuse the prefix of this file name. archive_cleanup_command is
part of recovery.conf, which gets loaded by the server at the
beginning of recovery by the startup process, so the command will get
executed continuously on a standby.
--
Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Dan | 2017-08-18 09:57:32 | Number of rows affected by ON CASCADE |
Previous Message | krishna chaitanya | 2017-08-17 15:43:03 | Re: Deleting unwanted wal files |