Re: Deleting unwanted wal files

Thanks for your reply, but will pg_basebackup generate a .backup file when
scheduled in cron job so that i can give that as input to
pg_archivecleanup. 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 ?

On 17 Aug 2017 8:01 p.m., "Michael Paquier" <michael(dot)paquier(at)gmail(dot)com>
wrote:

> On Thu, Aug 17, 2017 at 8:06 PM, krish050591 <krish050591(at)gmail(dot)com>
> wrote:
> > Hi, if i'm using pg_basebackup utility for taking my database backup and
> also
> > enabled wal level archiving, how will i detect the unwanted wal files and
> > how will it delete them ?
>
> Have you heard of pg_archivecleanup? Documentation is here:
> https://www.postgresql.org/docs/devel/static/pgarchivecleanup.html
> If a single archive is not cross-used among multiple standbys, you
> could use it with archive_cleanup_command is recovery.conf to remove
> unneeded WAL segments.
> --
> Michael
>