Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17BB4567@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory  (girish R G peetle <giri.anamika0@gmail.com>)
Responses Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory  (girish R G peetle <giri.anamika0@gmail.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Dan Kogan
Date:
Subject: Seemingly hanging checkpoint
Next
From: girish R G peetle
Date:
Subject: Re: pg_stop_backup is not archiving latest transaction log from pg_xlog directory