On Fri, Aug 18, 2017 at 12:43 AM, krishna chaitanya <krish050591@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general