> @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.
