Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory

On Wed, Jun 19, 2013 at 4:32 PM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>wrote:

> girish R G peetle wrote:
> > @Albe
> > Even I was thinking to backup the transaction log files under pg_xlog
> directory. But my concern is,
> > will it lead some kind of error or inconsistency ?
>
> No.
> During recovery, archived WAL files will overwrite the ones in
> pg_xlog. The WAL files in pg_xlog will only be used if
> no archived version is available.
>
> As long as pg_xlog is backed up after the end of
> pg_stop_backup(), you should be safe.
>
> Yours,
> Laurenz Albe
>

Hi Laurenz Albe,
I was wondering if I can use the modified version of your solution.

1. Convert output of pg_stop_backup to transaction log file name. (This
refers to the latest active transaction log file)
2. If we are able to see this file under archive(WAL) directory, backup
this file from this directory.
3. If the file is not found under archive(WAL) directory, backup this file
form pg_xlog directory.

Thanks
Girish